View: CE_CP_DISC_PAY_V

Product:	CE - Cash Management
Description:	Cash Positioning Discoverer View for Payroll Expenses
Implementation/DBA Data:	APPS.CE_CP_DISC_PAY_V

View Text

SELECT WSL.WORKSHEET_HEADER_ID
, PAY.BANK_ACCOUNT_ID
, WSL.WORKSHEET_LINE_ID
, WSL.DESCRIPTION
, TO_CHAR(PAY.REFERENCE_ID)
, -DECODE(PAY.CURRENCY_CODE
, XBA.CURRENCY_CODE
, PAY.AMOUNT
, PAY.BASE_AMOUNT)
, PAY.REFERENCE_ID FROM CE_PAY_FC_PAYROLL_V PAY
, CE_CP_WORKSHEET_LINES WSL
, CE_CP_XTR_BANK_ACCOUNTS_V XBA
WHERE PAY.TRX_DATE = TO_DATE(SYSDATE
, 'YYYY/MM/DD') AND WSL.SOURCE_TYPE = 'PAY' AND WSL.INCLUDE_FLAG = 'Y' AND (WSL.PAYROLL_ID IS NULL OR PAY.PAYROLL_ID = WSL.PAYROLL_ID) AND (WSL.RECEIPT_METHOD_ID IS NULL OR PAY.ORG_PAYMENT_METHOD_ID = WSL.RECEIPT_METHOD_ID) AND PAY.BANK_ACCOUNT_ID = XBA.BANK_ACCOUNT_ID

Columns