[Home] [Help]
View: CE_FC_APP_DISC_V
View Text
SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.CHECK_NUMBER
, -SRC.AMOUNT
, -NVL(SRC.BASE_AMOUNT
, SRC.AMOUNT)
, L.MEANING
, L2.MEANING
, SRC.PAYMENT_PRIORITY
, SRC.SUPPLIER_TYPE
, SRC.PAYGROUP
, HR.NAME FROM CE_AP_FC_PAYMENTS_V SRC
, FND_LOOKUP_VALUES L
, FND_LOOKUP_VALUES L2
, HR_OPERATING_UNITS HR
WHERE L.LOOKUP_TYPE = 'CHECK STATE'
AND L.LOOKUP_CODE(+) = SRC.STATUS
AND L.LANGUAGE = USERENV('LANG')
AND L2.LOOKUP_TYPE = 'PAYMENT METHOD' AND L2.LOOKUP_CODE(+) = SRC.PAYMENT_METHOD
AND L2.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 |
CHECK_NUMBER |
TRX_AMOUNT |
BANK_ACCOUNT_AMOUNT |
STATUS |
PAYMENT_METHOD |
PAYMENT_PRIORITY |
SUPPLIER_TYPE |
PAYGROUP |
ORGANIZATION |