APPS.IGC_CBC_PO_GRP dependencies on PO_LINES

Line 17: po_lines pol,

13: IS
14: SELECT max(pod.gl_encumbered_date)
15: ,min(pod.gl_encumbered_date)
16: FROM po_distributions pod,
17: po_lines pol,
18: po_line_locations poll
19: WHERE pol.po_header_id = p_document_id
20: AND NVL(pol.closed_code,'X') <> 'FINALLY CLOSED'
21: AND NVL(poll.closed_code,'X') <> 'FINALLY CLOSED'

Line 916: Po_lines pol,

912: MIN(bpa_h.cbc_accounting_date)
913: INTO l_max_bpa_accounting_date,
914: l_min_bpa_accounting_date
915: FROM po_headers bpa_h,
916: Po_lines pol,
917: Po_line_locations poll,
918: Po_distributions bpa_d
919: WHERE pol.po_header_id = p_document_id
920: AND poll.po_line_id = pol.po_line_id

Line 1113: Po_lines pol,

1109: -- Blanket Agreements for Standard Purchase Orders.
1110: Cursor c_max_bpa_po_date IS
1111: SELECT max(bpa_h.cbc_accounting_date)
1112: FROM po_headers bpa_h,
1113: Po_lines pol,
1114: Po_distributions bpa_d
1115: WHERE pol.po_header_id = p_document_id
1116: AND pol.from_header_id IS NOT NULL
1117: AND pol.from_header_id = bpa_d.po_header_id