APPS.IGC_CBC_PO_GRP dependencies on PO_LINE_LOCATIONS

Line 18: po_line_locations poll

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'
22: AND poll.shipment_type IN ('STANDARD','PLANNED')

Line 60: po_line_locations poll

56: IS
57: SELECT max(pod.gl_encumbered_date)
58: ,min(pod.gl_encumbered_date)
59: FROM po_distributions pod,
60: po_line_locations poll
61: WHERE pod.po_release_id = p_document_id
62: AND poll.po_release_id = p_document_id
63: AND NVL(poll.closed_code,'X') <> 'FINALLY CLOSED'
64: AND pod.line_location_id = poll.line_location_id

Line 792: po_line_locations poll

788: INTO l_max_cbc_acc_date,
789: l_min_cbc_acc_date
790: FROM po_requisition_headers prh,
791: po_requisition_lines prl,
792: po_line_locations poll
793: WHERE poll.po_header_id = p_document_id
794: AND poll.line_location_id = prl.line_location_id
795: AND prl.requisition_header_id = prh.requisition_header_id
796: AND NVL(prl.closed_code,'X') <> 'FINALLY CLOSED'

Line 811: po_line_locations poll

807: INTO l_max_cbc_acc_date,
808: l_min_cbc_acc_date
809: FROM po_requisition_headers prh,
810: po_requisition_lines prl,
811: po_line_locations poll
812: WHERE poll.po_release_id = p_document_id
813: AND prl.line_location_id = poll.line_location_id
814: AND prl.requisition_header_id = prh.requisition_header_id
815: AND NVL(prl.closed_code,'X') <> 'FINALLY CLOSED'

Line 917: Po_line_locations poll,

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
921: AND NVL(pol.closed_code,'X') <> 'FINALLY CLOSED'