DBA Data[Home] [Help]

APPS.JA_CN_SR_EXPORT_PKG dependencies on PO_VENDORS

Line 69: FROM PO_VENDORS pv, AP_INVOICES_ALL ai

65: SELECT DISTINCT
66: DECODE(ai.INVOICE_TYPE_LOOKUP_CODE, 'PAYMENT REQUEST', NULL,
67: PV.SEGMENT1) AS Supplier_Number
68: ,VENDOR_NAME AS Supplier_Name, VENDOR_NAME AS Supplier_Short_Name
69: FROM PO_VENDORS pv, AP_INVOICES_ALL ai
70: WHERE pv.VENDOR_ID = ai.VENDOR_ID
71: AND pv.EMPLOYEE_ID IS NULL --'Standard Supplier' only
72: AND ai.LEGAL_ENTITY_ID = pn_legal_entity_id --LEGAL_ENTITY_ID
73: AND to_char(ai.GL_DATE,'YYYY') = pv_accounting_year --Accounting Year