DBA Data[Home] [Help]

APPS.PO_AP_MERGE_GRP dependencies on PO_LINES

Line 254: po_lines_all POL

250: FROM dual
251: WHERE EXISTS (
252: SELECT NULL
253: FROM po_headers GA,
254: po_lines_all POL
255: WHERE GA.global_agreement_flag = 'Y'
256: AND GA.vendor_id = p_from_vendor_id
257: AND GA.vendor_site_id = p_from_site_id
258: AND POL.org_id <> GA.org_id

Line 292: po_lines POL,

288: FROM dual
289: WHERE EXISTS (
290: SELECT NULL
291: FROM po_headers GA,
292: po_lines POL,
293: po_headers POH
294: WHERE GA.global_agreement_flag = 'Y'
295: AND GA.vendor_id = p_from_vendor_id
296: AND GA.vendor_site_id = p_from_site_id

Line 370: po_lines POL,

366: FROM dual
367: WHERE EXISTS (
368: SELECT NULL
369: FROM po_headers POH,
370: po_lines POL,
371: po_headers_all GA
372: WHERE POH.vendor_id = p_from_vendor_id
373: AND POH.vendor_site_id = p_from_site_id
374: AND POH.po_header_id = POL.po_header_id