APPS.POS_ASN_XML dependencies on PO_LINE_LOCATIONS_ALL

Line 253: po_line_locations_all poll

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
257: rti.po_header_id = poh.po_header_id and

Line 332: from po_line_locations_all pll

328: p_transaction_type := 'SHIP';
329:
330: select pll.ship_to_location_id
331: into l_location_id
332: from po_line_locations_all pll
333: where pll.line_location_id = p_po_line_location_id;
334:
335: SELECT count(*)
336: INTO l_loc_count

Line 543: po_line_locations_all pll,

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
547: poh.Vendor_Site_ID IN

Line 567: po_line_locations_all pll,

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
571: poh.SEGMENT1 = p_po_number AND

Line 624: po_line_locations_all pll,

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
628: poh.Vendor_Site_ID IN

Line 648: po_line_locations_all pll,

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
652: poh.SEGMENT1 = p_po_number AND

Line 688: po_line_locations_all pll

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
692: pol.line_num = p_document_line_num and

Line 705: po_line_locations_all pll,

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
709: poh.po_header_id = pol.po_header_id and

Line 731: po_line_locations_all pll

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
735: pol.line_num = p_document_line_num and

Line 748: po_line_locations_all pll,

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
752: poh.po_header_id = pol.po_header_id and

Line 1039: po_line_locations_all pll,

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
1043: and POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 1060: po_line_locations_all pll,

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
1064: POH.PO_HEADER_ID = POL.PO_HEADER_ID

Line 1101: po_line_locations_all pll,

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
1105: and POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 1138: po_line_locations_all pll,

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
1142: POH.PO_HEADER_ID = POL.PO_HEADER_ID