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
247: rti.po_header_id = poh.po_header_id and
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
526: poh.Vendor_Site_ID IN
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
550: poh.SEGMENT1 = p_po_number AND
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
607: poh.Vendor_Site_ID IN
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
631: poh.SEGMENT1 = p_po_number AND
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
671: pol.line_num = p_document_line_num and
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
688: poh.po_header_id = pol.po_header_id and
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
714: pol.line_num = p_document_line_num and
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
731: poh.po_header_id = pol.po_header_id and
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
1012: and POL.PO_LINE_ID = PLL.PO_LINE_ID
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
1033: POH.PO_HEADER_ID = POL.PO_HEADER_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
1074: and POL.PO_LINE_ID = PLL.PO_LINE_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
1111: POH.PO_HEADER_ID = POL.PO_HEADER_ID