VIEW: APPS.IGI_AP_INVOICE_PAY_V

Source

View Text - Preformatted

SELECT distinct api.invoice_id, null, null, api.batch_id, api.vendor_id, apb.batch_name, pov.vendor_name, api.invoice_num, api.invoice_date, api.invoice_amount, fu.user_name, api.created_by, api.creation_date, api.last_updated_by, api.last_update_date, api.last_update_login, 'Y', api.rowid, api.org_id from ap_holds_all ah, ap_invoices api, ap_batches_all apb, fnd_user fu, po_vendors pov, igi_gcc_inst_options_all gcc WHERE api.batch_id = apb.batch_id(+) and api.vendor_id = pov.vendor_id(+) and gcc.org_id = api.org_id and gcc.option_name like 'SIA' and gcc.status_flag = 'Y' and fu.user_id = api.created_by and ah.hold_lookup_code = 'AWAIT_PAY_APP' and ah.release_lookup_code is null and ah.invoice_id = api.invoice_id and exists ( select 'X' from ap_holds_all ah where ah.hold_lookup_code = 'AWAIT_SEC_APP' and ah.release_lookup_code is not null and ah.invoice_id = api.invoice_id)

View Text - HTML Formatted

SELECT DISTINCT API.INVOICE_ID
, NULL
, NULL
, API.BATCH_ID
, API.VENDOR_ID
, APB.BATCH_NAME
, POV.VENDOR_NAME
, API.INVOICE_NUM
, API.INVOICE_DATE
, API.INVOICE_AMOUNT
, FU.USER_NAME
, API.CREATED_BY
, API.CREATION_DATE
, API.LAST_UPDATED_BY
, API.LAST_UPDATE_DATE
, API.LAST_UPDATE_LOGIN
, 'Y'
, API.ROWID
, API.ORG_ID
FROM AP_HOLDS_ALL AH
, AP_INVOICES API
, AP_BATCHES_ALL APB
, FND_USER FU
, PO_VENDORS POV
, IGI_GCC_INST_OPTIONS_ALL GCC
WHERE API.BATCH_ID = APB.BATCH_ID(+)
AND API.VENDOR_ID = POV.VENDOR_ID(+)
AND GCC.ORG_ID = API.ORG_ID
AND GCC.OPTION_NAME LIKE 'SIA'
AND GCC.STATUS_FLAG = 'Y'
AND FU.USER_ID = API.CREATED_BY
AND AH.HOLD_LOOKUP_CODE = 'AWAIT_PAY_APP'
AND AH.RELEASE_LOOKUP_CODE IS NULL
AND AH.INVOICE_ID = API.INVOICE_ID
AND EXISTS ( SELECT 'X'
FROM AP_HOLDS_ALL AH
WHERE AH.HOLD_LOOKUP_CODE = 'AWAIT_SEC_APP'
AND AH.RELEASE_LOOKUP_CODE IS NOT NULL
AND AH.INVOICE_ID = API.INVOICE_ID)