DBA Data[Home] [Help]

APPS.JA_JAINCTRB_XMLP_PKG dependencies on PO_VENDOR_SITES_ALL

Line 78: PO_VENDOR_SITES_ALL POVS

74: FROM
75: AP_INVOICES_ALL A,
76: AP_INVOICE_DISTRIBUTIONS_ALL B,
77: PO_VENDORS POV,
78: PO_VENDOR_SITES_ALL POVS
79: WHERE A.INVOICE_ID = B.INVOICE_ID
80: AND POV.VENDOR_ID = A.VENDOR_ID
81: AND POV.VENDOR_ID = POVS.VENDOR_ID
82: AND A.VENDOR_ID = NVL(P_VENDOR_ID

Line 102: PO_VENDOR_SITES_ALL POVS

98: FROM
99: AP_INVOICES_ALL A,
100: AP_INVOICE_DISTRIBUTIONS_ALL B,
101: PO_VENDORS POV,
102: PO_VENDOR_SITES_ALL POVS
103: WHERE A.INVOICE_ID = B.INVOICE_ID
104: AND POV.VENDOR_ID = A.VENDOR_ID
105: AND POV.VENDOR_ID = POVS.VENDOR_ID
106: AND A.VENDOR_ID = NVL(P_VENDOR_ID

Line 127: PO_VENDOR_SITES_ALL POVS

123: AP_INVOICES_ALL A,
124: AP_INVOICE_PAYMENTS_ALL B,
125: AP_CHECKS_ALL C,
126: PO_VENDORS POV,
127: PO_VENDOR_SITES_ALL POVS
128: WHERE A.INVOICE_ID = B.INVOICE_ID
129: AND POV.VENDOR_ID = A.VENDOR_ID
130: AND B.CHECK_ID = C.CHECK_ID
131: AND POV.VENDOR_ID = POVS.VENDOR_ID

Line 150: PO_VENDOR_SITES_ALL POVS

146: FROM
147: AP_INVOICES_ALL A,
148: AP_INVOICE_DISTRIBUTIONS_ALL B,
149: PO_VENDORS POV,
150: PO_VENDOR_SITES_ALL POVS
151: WHERE A.INVOICE_ID = B.INVOICE_ID
152: AND POV.VENDOR_ID = A.VENDOR_ID
153: AND POV.VENDOR_ID = POVS.VENDOR_ID
154: AND A.VENDOR_ID = NVL(P_VENDOR_ID

Line 200: PO_VENDOR_SITES_ALL POVS

196: FROM
197: AP_INVOICES_ALL A,
198: AP_INVOICE_DISTRIBUTIONS_ALL B,
199: PO_VENDORS POV,
200: PO_VENDOR_SITES_ALL POVS
201: WHERE A.INVOICE_ID = B.INVOICE_ID
202: AND POV.VENDOR_ID = A.VENDOR_ID
203: AND POVS.VENDOR_ID = POV.VENDOR_ID
204: AND A.VENDOR_ID = NVL(P_VENDOR_ID

Line 231: PO_VENDOR_SITES_ALL POVS

227: AP_INVOICES_ALL A,
228: AP_INVOICE_PAYMENTS_ALL B,
229: AP_CHECKS_ALL C,
230: PO_VENDORS POV,
231: PO_VENDOR_SITES_ALL POVS
232: WHERE A.INVOICE_ID = B.INVOICE_ID
233: AND POV.VENDOR_ID = A.VENDOR_ID
234: AND B.CHECK_ID = C.CHECK_ID
235: AND POVS.VENDOR_ID = POV.VENDOR_ID

Line 258: PO_VENDOR_SITES_ALL POVS

254: FROM
255: AP_INVOICES_ALL A,
256: AP_INVOICE_DISTRIBUTIONS_ALL B,
257: PO_VENDORS POV,
258: PO_VENDOR_SITES_ALL POVS
259: WHERE A.INVOICE_ID = B.INVOICE_ID
260: AND POV.VENDOR_ID = A.VENDOR_ID
261: AND POVS.VENDOR_ID = POV.VENDOR_ID
262: AND A.VENDOR_ID = NVL(P_VENDOR_ID

Line 285: PO_VENDOR_SITES_ALL POVS

281: FROM
282: AP_INVOICES_ALL B,
283: AP_INVOICE_DISTRIBUTIONS_ALL A,
284: PO_VENDORS POV,
285: PO_VENDOR_SITES_ALL POVS
286: WHERE A.INVOICE_ID = B.INVOICE_ID
287: AND POV.VENDOR_ID = B.VENDOR_ID
288: AND B.VENDOR_ID = NVL(P_VENDOR_ID
289: ,B.VENDOR_ID)

Line 378: PO_VENDOR_SITES_ALL POVS,

374: FROM
375: AP_INVOICES_ALL A,
376: AP_INVOICE_DISTRIBUTIONS_ALL B,
377: PO_VENDORS POV,
378: PO_VENDOR_SITES_ALL POVS,
379: XLA_AE_LINES XAL,
380: XLA_AE_HEADERS XAH,
381: XLA_TRANSACTION_ENTITIES XTE
382: WHERE A.INVOICE_ID = B.INVOICE_ID