[Home] [Help]
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
Name |
WORKSHEET_HEADER_ID |
BANK_ACCOUNT_ID |
WORKSHEET_LINE_ID |
DESCRIPTION |
DETAIL |
BALANCE |
REFERENCE_ID |