APPS.PO_AP_MERGE_GRP dependencies on PO_HEADERS

Line 87: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

83: -- p_vendor_site_code IN PO_VENDOR_SITES_ALL.vendor_site_code%TYPE
84: -- ) RETURN BOOLEAN;
85: --
86: --FUNCTION referencing_asl_exist
87: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
88: -- p_call_from IN VARCHAR2
89: --) RETURN BOOLEAN;
90: --
91: --FUNCTION referencing_docs_exist

Line 92: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

88: -- p_call_from IN VARCHAR2
89: --) RETURN BOOLEAN;
90: --
91: --FUNCTION referencing_docs_exist
92: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
93: --) RETURN BOOLEAN;
94: --
95:
96: --

Line 216: FROM po_headers GA,

212: INTO l_pass_val
213: FROM dual
214: WHERE EXISTS (
215: SELECT NULL
216: FROM po_headers GA,
217: po_ga_org_assignments PGOA
218: WHERE GA.global_agreement_flag = 'Y'
219: AND GA.vendor_id = p_from_vendor_id
220: AND GA.vendor_site_id = p_from_site_id

Line 253: FROM po_headers GA,

249: INTO l_pass_val
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

Line 291: FROM po_headers GA,

287: INTO l_pass_val
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

Line 293: po_headers POH

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
297: AND GA.po_header_id IN (POL.contract_id,

Line 331: FROM po_headers_all GA,

327: INTO l_pass_val
328: FROM dual
329: WHERE EXISTS (
330: SELECT NULL
331: FROM po_headers_all GA,
332: po_ga_org_assignments PGOA
333: WHERE GA.global_agreement_flag = 'Y'
334: AND GA.vendor_id = p_from_vendor_id
335: AND GA.po_header_id = PGOA.po_header_id

Line 369: FROM po_headers POH,

365: INTO l_pass_val
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

Line 371: po_headers_all GA

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
375: AND GA.po_header_id IN (POL.contract_id,

Line 412: po_headers_all GA

408: FROM dual
409: WHERE EXISTS (
410: SELECT NULL
411: FROM po_requisition_lines RL,
412: po_headers_all GA
413: WHERE RL.vendor_id = p_from_vendor_id
414: AND RL.blanket_po_header_id = GA.po_header_id
415: AND GA.global_agreement_flag = 'Y'
416: AND GA.org_id <> RL.org_id);

Line 450: po_headers GA

446: FROM dual
447: WHERE EXISTS (
448: SELECT NULL
449: FROM po_requisition_lines_all RL,
450: po_headers GA
451: WHERE RL.vendor_id = p_from_vendor_id
452: AND RL.vendor_site_id = p_from_site_id
453: AND RL.blanket_po_header_id = GA.po_header_id
454: AND GA.global_agreement_flag = 'Y'

Line 489: po_headers GA

485: FROM dual
486: WHERE EXISTS (
487: SELECT NULL
488: FROM po_requisition_lines_all RL,
489: po_headers GA
490: WHERE GA.vendor_id = p_from_vendor_id
491: AND GA.vendor_site_id = p_from_site_id
492: AND GA.global_agreement_flag = 'Y'
493: AND GA.po_header_id = RL.blanket_po_header_id