VIEW: APPS.PAY_PAYMENT_COSTS_V

Source

View Text - Preformatted

SELECT OPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD_NAME , PCOS.ACCOUNTING_DATE ACCOUNTING_DATE , HR_GENERAL.DECODE_LOOKUP('PAY_COST_ACCOUNT_TYPE', PCOS.ACCOUNT_TYPE) COST_TYPE, HR_GENERAL.DECODE_LOOKUP('DEBIT_CREDIT', PCOS.DEBIT_OR_CREDIT ) DEBIT_OR_CREDIT, HR_CHKFMT.CHANGEFORMAT(PCOS.VALUE, 'M', PCOS.CURRENCY_CODE) COSTED_VALUE, PCOS.SOURCE_TYPE SOURCE_TYPE, PCOS.SOURCE_ACTION_ID SOURCE_ACTION_ID, PCOS.ACCOUNT_ID GL_ACCOUNT_CCID, GCC.CHART_OF_ACCOUNTS_ID FLEX_NUM, PCOS.ASSIGNMENT_ID, PCOS.ASSIGNMENT_ACTION_ID, PCOS.PRE_PAYMENT_ID, PCOS.PAYMENT_COST_ID FROM PAY_PAYMENT_COSTS PCOS, PAY_PRE_PAYMENTS PPP, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PAC, GL_CODE_COMBINATIONS GCC WHERE PCOS.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID AND PPP.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND PAA.ASSIGNMENT_ACTION_ID = PCOS.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID AND PAC.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE AND GCC.CODE_COMBINATION_ID = PCOS.ACCOUNT_ID

View Text - HTML Formatted

SELECT OPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD_NAME
, PCOS.ACCOUNTING_DATE ACCOUNTING_DATE
, HR_GENERAL.DECODE_LOOKUP('PAY_COST_ACCOUNT_TYPE'
, PCOS.ACCOUNT_TYPE) COST_TYPE
, HR_GENERAL.DECODE_LOOKUP('DEBIT_CREDIT'
, PCOS.DEBIT_OR_CREDIT ) DEBIT_OR_CREDIT
, HR_CHKFMT.CHANGEFORMAT(PCOS.VALUE
, 'M'
, PCOS.CURRENCY_CODE) COSTED_VALUE
, PCOS.SOURCE_TYPE SOURCE_TYPE
, PCOS.SOURCE_ACTION_ID SOURCE_ACTION_ID
, PCOS.ACCOUNT_ID GL_ACCOUNT_CCID
, GCC.CHART_OF_ACCOUNTS_ID FLEX_NUM
, PCOS.ASSIGNMENT_ID
, PCOS.ASSIGNMENT_ACTION_ID
, PCOS.PRE_PAYMENT_ID
, PCOS.PAYMENT_COST_ID
FROM PAY_PAYMENT_COSTS PCOS
, PAY_PRE_PAYMENTS PPP
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PAC
, GL_CODE_COMBINATIONS GCC
WHERE PCOS.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID
AND PPP.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND PAA.ASSIGNMENT_ACTION_ID = PCOS.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PAC.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
AND GCC.CODE_COMBINATION_ID = PCOS.ACCOUNT_ID