APPS.POS_ASN_XML dependencies on PO_LINES_ALL

Line 242: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,

238: p_line_num,
239: p_po_shipment_line_num,
240: p_error_message
241: from
242: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,
243: po_line_locations_all poll
244: where
245: pie.interface_header_id = rti.header_interface_id and
246: pie.interface_type in ('RECEIVING','RCV-856') and

Line 521: po_lines_all pol,

517: SELECT count(*)
518: INTO l_count_num
519: FROM
520: po_headers_all poh,
521: po_lines_all pol,
522: po_line_locations_all pll,
523: Mtl_system_items_kfv msi
524: WHERE
525: poh.SEGMENT1 = p_po_number AND

Line 545: po_lines_all pol,

541: SELECT count(*)
542: INTO l_count_num
543: FROM
544: po_headers_all poh,
545: po_lines_all pol,
546: po_line_locations_all pll,
547: po_releases_all prl,
548: Mtl_system_items_kfv msi
549: WHERE

Line 602: po_lines_all pol,

598: SELECT min(poh.ORG_ID)
599: INTO p_org_id
600: FROM
601: po_headers_all poh,
602: po_lines_all pol,
603: po_line_locations_all pll,
604: Mtl_system_items_kfv msi
605: WHERE
606: poh.SEGMENT1 = p_po_number AND

Line 626: po_lines_all pol,

622: SELECT min(poh.ORG_ID)
623: INTO p_org_id
624: FROM
625: po_headers_all poh,
626: po_lines_all pol,
627: po_line_locations_all pll,
628: po_releases_all prl,
629: Mtl_system_items_kfv msi
630: WHERE

Line 666: po_lines_all pol,

662: into
663: x_ship_org_num
664: from
665: po_headers_all poh,
666: po_lines_all pol,
667: po_line_locations_all pll
668: where
669: poh.po_header_id = p_po_header_id and
670: poh.po_header_id = pol.po_header_id and

Line 683: po_lines_all pol,

679: into
680: x_ship_org_num
681: from
682: po_headers_all poh,
683: po_lines_all pol,
684: po_line_locations_all pll,
685: po_releases_all prl
686: where
687: poh.po_header_id = p_po_header_id and

Line 709: po_lines_all pol,

705: into
706: p_ship_to_org_id
707: from
708: po_headers_all poh,
709: po_lines_all pol,
710: po_line_locations_all pll
711: where
712: poh.po_header_id = p_po_header_id and
713: poh.po_header_id = pol.po_header_id and

Line 726: po_lines_all pol,

722: into
723: p_ship_to_org_id
724: from
725: po_headers_all poh,
726: po_lines_all pol,
727: po_line_locations_all pll,
728: po_releases_all prl
729: where
730: poh.po_header_id = p_po_header_id and

Line 1007: po_lines_all pol,

1003: INTO
1004: l_count
1005: FROM
1006: po_headers_all poh,
1007: po_lines_all pol,
1008: po_line_locations_all pll,
1009: MTL_SYSTEM_ITEMS_KFV MSI
1010: WHERE
1011: POH.PO_HEADER_ID = POL.PO_HEADER_ID

Line 1028: po_lines_all pol,

1024: INTO
1025: l_count
1026: FROM
1027: po_headers_all poh,
1028: po_lines_all pol,
1029: po_line_locations_all pll,
1030: po_releases_all prl,
1031: MTL_SYSTEM_ITEMS_KFV MSI
1032: WHERE

Line 1069: po_lines_all pol,

1065: p_line_location_id,
1066: p_ship_to_org_id
1067: FROM
1068: po_headers_all poh,
1069: po_lines_all pol,
1070: po_line_locations_all pll,
1071: MTL_SYSTEM_ITEMS_KFV MSI
1072: WHERE
1073: POH.PO_HEADER_ID = POL.PO_HEADER_ID

Line 1106: po_lines_all pol,

1102: p_ship_to_org_id,
1103: p_po_release_id
1104: FROM
1105: po_headers_all poh,
1106: po_lines_all pol,
1107: po_line_locations_all pll,
1108: po_releases_all prl,
1109: MTL_SYSTEM_ITEMS_KFV MSI
1110: WHERE