VIEW: APPS.IGI_EXP_AP_INV_V

Source

View Text - Preformatted

SELECT i.rowid row_id , i.invoice_id , i.invoice_num , i.description , v.vendor_name , i.vendor_id , s.vendor_site_code , i.vendor_site_id , i.invoice_amount , f.user_name , i.created_by , i.creation_date , i.invoice_type_lookup_code , i.invoice_currency_code FROM AP_HOLDS H,AP_INVOICES I,FND_USER F,IGI_AP_INVOICES IAI,PO_VENDORS V,PO_VENDOR_SITES S WHERE i.vendor_id = v.vendor_id AND i.vendor_site_id = s.vendor_site_id AND i.created_by = f.user_id AND iai.dial_unit_id is null AND i.invoice_id = h.invoice_id AND i.invoice_id = iai.invoice_id(+) AND h.hold_lookup_code = 'AWAIT EXP APP' AND h.release_lookup_code IS NULL AND EXISTS (SELECT 1 FROM ap_invoice_distributions d WHERE d.invoice_id = i.invoice_id AND nvl(d.posted_flag,'N') = 'N')

View Text - HTML Formatted

SELECT I.ROWID ROW_ID
, I.INVOICE_ID
, I.INVOICE_NUM
, I.DESCRIPTION
, V.VENDOR_NAME
, I.VENDOR_ID
, S.VENDOR_SITE_CODE
, I.VENDOR_SITE_ID
, I.INVOICE_AMOUNT
, F.USER_NAME
, I.CREATED_BY
, I.CREATION_DATE
, I.INVOICE_TYPE_LOOKUP_CODE
, I.INVOICE_CURRENCY_CODE
FROM AP_HOLDS H
, AP_INVOICES I
, FND_USER F
, IGI_AP_INVOICES IAI
, PO_VENDORS V
, PO_VENDOR_SITES S
WHERE I.VENDOR_ID = V.VENDOR_ID
AND I.VENDOR_SITE_ID = S.VENDOR_SITE_ID
AND I.CREATED_BY = F.USER_ID
AND IAI.DIAL_UNIT_ID IS NULL
AND I.INVOICE_ID = H.INVOICE_ID
AND I.INVOICE_ID = IAI.INVOICE_ID(+)
AND H.HOLD_LOOKUP_CODE = 'AWAIT EXP APP'
AND H.RELEASE_LOOKUP_CODE IS NULL
AND EXISTS (SELECT 1
FROM AP_INVOICE_DISTRIBUTIONS D
WHERE D.INVOICE_ID = I.INVOICE_ID
AND NVL(D.POSTED_FLAG
, 'N') = 'N')