VIEW: APPS.IEX_PAY_OKL_CONTRACTS_V

Source

View Text - Preformatted

SELECT CAO.CAS_ID, CAO.CAS_ID, NULL, NULL, CON.CONTRACT_ID, CON.CONTRACT_NUMBER, CON.CUSTOMER_ID, CON.CUSTOMER_NUMBER, CON.AMOUNT, CON.CURRENCY_CODE, NULL, con.CUSTOMER_SITE_USE_ID FROM IEX_CASE_OBJECTS CAO, IEX_BPD_CONTRACT_REMAINING_V CON WHERE CON.CONTRACT_ID = CAO.OBJECT_ID AND CAO.OBJECT_CODE = 'CONTRACTS'

View Text - HTML Formatted

SELECT CAO.CAS_ID
, CAO.CAS_ID
, NULL
, NULL
, CON.CONTRACT_ID
, CON.CONTRACT_NUMBER
, CON.CUSTOMER_ID
, CON.CUSTOMER_NUMBER
, CON.AMOUNT
, CON.CURRENCY_CODE
, NULL
, CON.CUSTOMER_SITE_USE_ID
FROM IEX_CASE_OBJECTS CAO
, IEX_BPD_CONTRACT_REMAINING_V CON
WHERE CON.CONTRACT_ID = CAO.OBJECT_ID
AND CAO.OBJECT_CODE = 'CONTRACTS'