APPS.POS_ASN_XML dependencies on PO_LINES_ALL

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

248: p_line_num,
249: p_po_shipment_line_num,
250: p_error_message
251: from
252: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,
253: po_line_locations_all poll
254: where
255: pie.interface_header_id = rti.header_interface_id and
256: pie.interface_type in ('RECEIVING','RCV-856') and

Line 542: po_lines_all pol,

538: SELECT count(*)
539: INTO l_count_num
540: FROM
541: po_headers_all poh,
542: po_lines_all pol,
543: po_line_locations_all pll,
544: Mtl_system_items_kfv msi
545: WHERE
546: poh.SEGMENT1 = p_po_number AND

Line 566: po_lines_all pol,

562: SELECT count(*)
563: INTO l_count_num
564: FROM
565: po_headers_all poh,
566: po_lines_all pol,
567: po_line_locations_all pll,
568: po_releases_all prl,
569: Mtl_system_items_kfv msi
570: WHERE

Line 623: po_lines_all pol,

619: SELECT min(poh.ORG_ID)
620: INTO p_org_id
621: FROM
622: po_headers_all poh,
623: po_lines_all pol,
624: po_line_locations_all pll,
625: Mtl_system_items_kfv msi
626: WHERE
627: poh.SEGMENT1 = p_po_number AND

Line 647: po_lines_all pol,

643: SELECT min(poh.ORG_ID)
644: INTO p_org_id
645: FROM
646: po_headers_all poh,
647: po_lines_all pol,
648: po_line_locations_all pll,
649: po_releases_all prl,
650: Mtl_system_items_kfv msi
651: WHERE

Line 687: po_lines_all pol,

683: into
684: x_ship_org_num
685: from
686: po_headers_all poh,
687: po_lines_all pol,
688: po_line_locations_all pll
689: where
690: poh.po_header_id = p_po_header_id and
691: poh.po_header_id = pol.po_header_id and

Line 704: po_lines_all pol,

700: into
701: x_ship_org_num
702: from
703: po_headers_all poh,
704: po_lines_all pol,
705: po_line_locations_all pll,
706: po_releases_all prl
707: where
708: poh.po_header_id = p_po_header_id and

Line 730: po_lines_all pol,

726: into
727: p_ship_to_org_id
728: from
729: po_headers_all poh,
730: po_lines_all pol,
731: po_line_locations_all pll
732: where
733: poh.po_header_id = p_po_header_id and
734: poh.po_header_id = pol.po_header_id and

Line 747: po_lines_all pol,

743: into
744: p_ship_to_org_id
745: from
746: po_headers_all poh,
747: po_lines_all pol,
748: po_line_locations_all pll,
749: po_releases_all prl
750: where
751: poh.po_header_id = p_po_header_id and

Line 1038: po_lines_all pol,

1034: INTO
1035: l_count
1036: FROM
1037: po_headers_all poh,
1038: po_lines_all pol,
1039: po_line_locations_all pll,
1040: MTL_SYSTEM_ITEMS_KFV MSI
1041: WHERE
1042: POH.PO_HEADER_ID = POL.PO_HEADER_ID

Line 1059: po_lines_all pol,

1055: INTO
1056: l_count
1057: FROM
1058: po_headers_all poh,
1059: po_lines_all pol,
1060: po_line_locations_all pll,
1061: po_releases_all prl,
1062: MTL_SYSTEM_ITEMS_KFV MSI
1063: WHERE

Line 1100: po_lines_all pol,

1096: p_line_location_id,
1097: p_ship_to_org_id
1098: FROM
1099: po_headers_all poh,
1100: po_lines_all pol,
1101: po_line_locations_all pll,
1102: MTL_SYSTEM_ITEMS_KFV MSI
1103: WHERE
1104: POH.PO_HEADER_ID = POL.PO_HEADER_ID

Line 1137: po_lines_all pol,

1133: p_ship_to_org_id,
1134: p_po_release_id
1135: FROM
1136: po_headers_all poh,
1137: po_lines_all pol,
1138: po_line_locations_all pll,
1139: po_releases_all prl,
1140: MTL_SYSTEM_ITEMS_KFV MSI
1141: WHERE