[Home] [Help]
View: CE_FC_PAT_DISC_V
View Text
SELECT TO_CHAR(SRC.REFERENCE_ID)
, NULL
, -SRC.AMOUNT
, L.MEANING
, SRC.EXPENDITURE_TYPE
, SRC.EXPENDITURE_ITEM_DATE
, SRC.QUANTITY
, HR.NAME FROM PA_CE_TRANSACTIONS_V SRC
, FND_LOOKUP_VALUES L
, HR_OPERATING_UNITS HR
WHERE L.LOOKUP_TYPE = 'EXPENDITURE STATUS'
AND L.LOOKUP_CODE = SRC.EXPENDITURE_STATUS_CODE
AND L.LANGUAGE = USERENV('LANG')
AND 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 |
TRX_NUMBER |
TRX_AMOUNT |
EXPENDITURE_STATUS |
EXPENDITURE_TYPE |
EXPENDITURE_ITEM_DATE |
QUANTITY |
ORGANIZATION |