query -Y/N lag
SELECT
NVL(bb_MultiC.PAYRUN_ID, PRD_ML.PAYRUN_ID) AS PAYRUN_ID,
NVL(bb_MultiC.PAYMENT_BATCH_PERIOD, PRD_ML.PERIOD_ID) AS PERIOD_ID,
NVL(bb_MultiC.PAYEE_PARTICIPANT_ID, PRD_ML.PARTICIPANT_ID) AS PARTICIPANT_ID,
NVL(bb_MultiC.BBMultiCurrencyFlag, 'N') AS BBMultiCurrencyFlag,
NVL(PRD_ML.MULTI_CURR_YN, 'N') AS MULTI_CURR_YN
FROM BB_MULTI_CURRENCY bb_MultiC
FULL OUTER JOIN PERIOD_MULTI_CURRENCY PRD_ML
ON bb_MultiC.PAYEE_PARTICIPANT_ID = PRD_ML.PARTICIPANT_ID
AND bb_MultiC.PAYRUN_ID = PRD_ML.PAYRUN_ID
AND bb_MultiC.PAYMENT_BATCH_PERIOD = PRD_ML.PERIOD_ID
WHERE NVL(PRD_ML.MULTI_CURR_YN, 'N') = 'Y'
OR NVL(bb_MultiC.BBMultiCurrencyFlag, 'N') = 'Y'
Comments
Post a Comment