VIEW: APPS.PAY_XLA_PAYMENT_COSTS_V

Source

View Text - Preformatted

SELECT PXE.EVENT_ID, PPC.PAYMENT_COST_ID, TGL_AA.ASSIGNMENT_ACTION_ID, PPC.ASSIGNMENT_ACTION_ID, PPC.VALUE, PPC.DEBIT_OR_CREDIT, PPC.CURRENCY_CODE, PPC.ACCOUNT_ID, PPC.ACCOUNT_TYPE, PPC.ACCOUNTING_DATE FROM PAY_XLA_EVENTS PXE, PAY_ASSIGNMENT_ACTIONS TGL_AA, PAY_ACTION_INTERLOCKS COST_LOCK, PAY_ASSIGNMENT_ACTIONS COST_AA, PAY_PAYROLL_ACTIONS COST_PA, PAY_PAYMENT_COSTS PPC WHERE TGL_AA.ASSIGNMENT_ACTION_ID = PXE.ASSIGNMENT_ACTION_ID AND COST_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID AND COST_AA.ASSIGNMENT_ACTION_ID = COST_LOCK.LOCKED_ACTION_ID AND COST_PA.PAYROLL_ACTION_ID = COST_AA.PAYROLL_ACTION_ID AND COST_PA.ACTION_TYPE = 'CP' AND PPC.ASSIGNMENT_ACTION_ID = COST_AA.ASSIGNMENT_ACTION_ID AND PPC.TRANSFER_TO_GL_FLAG = 'Y' AND PPC.ACCOUNTING_DATE = PXE.ACCOUNTING_DATE

View Text - HTML Formatted

SELECT PXE.EVENT_ID
, PPC.PAYMENT_COST_ID
, TGL_AA.ASSIGNMENT_ACTION_ID
, PPC.ASSIGNMENT_ACTION_ID
, PPC.VALUE
, PPC.DEBIT_OR_CREDIT
, PPC.CURRENCY_CODE
, PPC.ACCOUNT_ID
, PPC.ACCOUNT_TYPE
, PPC.ACCOUNTING_DATE
FROM PAY_XLA_EVENTS PXE
, PAY_ASSIGNMENT_ACTIONS TGL_AA
, PAY_ACTION_INTERLOCKS COST_LOCK
, PAY_ASSIGNMENT_ACTIONS COST_AA
, PAY_PAYROLL_ACTIONS COST_PA
, PAY_PAYMENT_COSTS PPC
WHERE TGL_AA.ASSIGNMENT_ACTION_ID = PXE.ASSIGNMENT_ACTION_ID
AND COST_LOCK.LOCKING_ACTION_ID = TGL_AA.ASSIGNMENT_ACTION_ID
AND COST_AA.ASSIGNMENT_ACTION_ID = COST_LOCK.LOCKED_ACTION_ID
AND COST_PA.PAYROLL_ACTION_ID = COST_AA.PAYROLL_ACTION_ID
AND COST_PA.ACTION_TYPE = 'CP'
AND PPC.ASSIGNMENT_ACTION_ID = COST_AA.ASSIGNMENT_ACTION_ID
AND PPC.TRANSFER_TO_GL_FLAG = 'Y'
AND PPC.ACCOUNTING_DATE = PXE.ACCOUNTING_DATE