VIEW: APPS.PAY_PRE_PAYMENTS_V3

Source

View Text - Preformatted

SELECT PPP.PRE_PAYMENT_ID , PPP.VALUE , OPM.CURRENCY_CODE , PPM.EXTERNAL_ACCOUNT_ID , FLX.ID_FLEX_NUM , OPM.EFFECTIVE_START_DATE OPM_EFFECTIVE_START_DATE , OPM.EFFECTIVE_END_DATE OPM_EFFECTIVE_END_DATE , PPM.EFFECTIVE_START_DATE PPM_EFFECTIVE_START_DATE , PPM.EFFECTIVE_END_DATE PPM_EFFECTIVE_END_DATE , OPM.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID FROM FND_ID_FLEX_STRUCTURES_VL FLX, PAY_PAYMENT_TYPES PTY, PAY_PERSONAL_PAYMENT_METHODS_F PPM, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_PRE_PAYMENTS PPP WHERE OPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID AND PPM.PERSONAL_PAYMENT_METHOD_ID = PPP.PERSONAL_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PTY.PAYMENT_TYPE_ID AND FLX.ID_FLEX_STRUCTURE_NAME (+) = PTY.TERRITORY_CODE||' Bank Details'

View Text - HTML Formatted

SELECT PPP.PRE_PAYMENT_ID
, PPP.VALUE
, OPM.CURRENCY_CODE
, PPM.EXTERNAL_ACCOUNT_ID
, FLX.ID_FLEX_NUM
, OPM.EFFECTIVE_START_DATE OPM_EFFECTIVE_START_DATE
, OPM.EFFECTIVE_END_DATE OPM_EFFECTIVE_END_DATE
, PPM.EFFECTIVE_START_DATE PPM_EFFECTIVE_START_DATE
, PPM.EFFECTIVE_END_DATE PPM_EFFECTIVE_END_DATE
, OPM.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
FROM FND_ID_FLEX_STRUCTURES_VL FLX
, PAY_PAYMENT_TYPES PTY
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_PRE_PAYMENTS PPP
WHERE OPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PPM.PERSONAL_PAYMENT_METHOD_ID = PPP.PERSONAL_PAYMENT_METHOD_ID
AND OPM.PAYMENT_TYPE_ID = PTY.PAYMENT_TYPE_ID
AND FLX.ID_FLEX_STRUCTURE_NAME (+) = PTY.TERRITORY_CODE||' BANK DETAILS'