[Home] [Help]
View: CE_FC_APX_DISC_V
View Text
SELECT 'AP' || TO_CHAR(SRC.REPORT_HEADER_ID)
, SRC.INVOICE_NUM
, TO_NUMBER(NULL)
, SRC.SOURCE
, DECODE(NVL(SRC.HOLD_LOOKUP_CODE
, 'N')
, 'Y'
, 'YES'
, 'NO')
, HR.NAME FROM AP_EXPENSE_REPORT_HEADERS_ALL SRC
, HR_OPERATING_UNITS HR
WHERE HR.ORGANIZATION_ID(+) = SRC.ORG_ID
AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID
AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT')) UNION ALL SELECT TO_CHAR(SRC.EXPENDITURE_ITEM_ID)
, NULL
, -SRC.AMOUNT
, SRC.TRANSACTION_SOURCE
, DECODE(SRC.BILL_HOLD_FLAG
, 'Y'
, 'YES'
, 'NO')
, HR.NAME FROM PA_CE_EXP_REPORTS_V SRC
, HR_OPERATING_UNITS HR
WHERE HR.ORGANIZATION_ID(+) = SRC.ORG_ID
AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID
AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT'))
Columns
Name |
REFERENCE_ID |
INVOICE_NUM |
TRX_AMOUNT |
SOURCE |
ON_HOLD |
ORGANIZATION |