eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_RCV_DIR_RCPT_APIS dependencies on MTL_SYSTEM_ITEMS

Line 39: from mtl_system_items

35: l_valid_subinventory BOOLEAN;
36:
37: CURSOR Get_Item_No IS
38: select segment1
39: from mtl_system_items
40: where inventory_item_id = p_item_id and
41: organization_id=p_organization_id;
42:
43: BEGIN

Line 275: MTL_SYSTEM_ITEMS MSI,

271: PO_HEADERS POH,
272: PO_LINE_LOCATIONS POLL,
273: PO_LINES POL,
274: PO_RELEASES POR,
275: MTL_SYSTEM_ITEMS MSI,
276: MTL_UNITS_OF_MEASURE mum,
277: PO_DISTRIBUTIONS POD
278: WHERE
279: POD.PO_DISTRIBUTION_ID = v_po_distribution_id

Line 351: from mtl_system_items

347: IF p_item_id IS NOT NULL THEN
348: BEGIN
349: select primary_unit_of_measure
350: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
351: from mtl_system_items
352: where mtl_system_items.inventory_item_id = p_item_id
353: and mtl_system_items.organization_id = p_organization_id;
354: EXCEPTION
355: when no_data_found then

Line 352: where mtl_system_items.inventory_item_id = p_item_id

348: BEGIN
349: select primary_unit_of_measure
350: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
351: from mtl_system_items
352: where mtl_system_items.inventory_item_id = p_item_id
353: and mtl_system_items.organization_id = p_organization_id;
354: EXCEPTION
355: when no_data_found then
356: NULL;

Line 353: and mtl_system_items.organization_id = p_organization_id;

349: select primary_unit_of_measure
350: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
351: from mtl_system_items
352: where mtl_system_items.inventory_item_id = p_item_id
353: and mtl_system_items.organization_id = p_organization_id;
354: EXCEPTION
355: when no_data_found then
356: NULL;
357:

Line 733: MTL_SYSTEM_ITEMS MSI,

729: PO_HEADERS POH,
730: PO_LINE_LOCATIONS POLL,
731: PO_LINES POL,
732: PO_RELEASES POR,
733: MTL_SYSTEM_ITEMS MSI,
734: MTL_UNITS_OF_MEASURE mum,
735: PO_DISTRIBUTIONS POD
736: WHERE
737: POD.PO_DISTRIBUTION_ID = v_po_distribution_id

Line 814: from mtl_system_items

810: IF p_item_id IS NOT NULL THEN
811: BEGIN
812: select primary_unit_of_measure
813: into gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
814: from mtl_system_items
815: where mtl_system_items.inventory_item_id = p_item_id
816: and mtl_system_items.organization_id = p_organization_id;
817: EXCEPTION
818: when no_data_found then

Line 815: where mtl_system_items.inventory_item_id = p_item_id

811: BEGIN
812: select primary_unit_of_measure
813: into gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
814: from mtl_system_items
815: where mtl_system_items.inventory_item_id = p_item_id
816: and mtl_system_items.organization_id = p_organization_id;
817: EXCEPTION
818: when no_data_found then
819: NULL;

Line 816: and mtl_system_items.organization_id = p_organization_id;

812: select primary_unit_of_measure
813: into gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
814: from mtl_system_items
815: where mtl_system_items.inventory_item_id = p_item_id
816: and mtl_system_items.organization_id = p_organization_id;
817: EXCEPTION
818: when no_data_found then
819: NULL;
820:

Line 1269: MTL_SYSTEM_ITEMS MSI,

1265: RCV_SHIPMENT_HEADERS RSH,
1266: RCV_SHIPMENT_LINES RSL,
1267: PO_REQUISITION_HEADERS PORH,
1268: PO_REQUISITION_LINES PORL,
1269: MTL_SYSTEM_ITEMS MSI,
1270: MTL_SYSTEM_ITEMS MSI1,
1271: MTL_UNITS_OF_MEASURE MUM
1272: WHERE
1273: RSH.RECEIPT_SOURCE_CODE <> 'VENDOR'

Line 1270: MTL_SYSTEM_ITEMS MSI1,

1266: RCV_SHIPMENT_LINES RSL,
1267: PO_REQUISITION_HEADERS PORH,
1268: PO_REQUISITION_LINES PORL,
1269: MTL_SYSTEM_ITEMS MSI,
1270: MTL_SYSTEM_ITEMS MSI1,
1271: MTL_UNITS_OF_MEASURE MUM
1272: WHERE
1273: RSH.RECEIPT_SOURCE_CODE <> 'VENDOR'
1274: AND RSL.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID(+)

Line 1355: from mtl_system_items

1351:
1352: BEGIN
1353: select primary_unit_of_measure
1354: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1355: from mtl_system_items
1356: where mtl_system_items.inventory_item_id = p_item_id
1357: and mtl_system_items.organization_id = p_organization_id;
1358: EXCEPTION
1359: when no_data_found then

Line 1356: where mtl_system_items.inventory_item_id = p_item_id

1352: BEGIN
1353: select primary_unit_of_measure
1354: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1355: from mtl_system_items
1356: where mtl_system_items.inventory_item_id = p_item_id
1357: and mtl_system_items.organization_id = p_organization_id;
1358: EXCEPTION
1359: when no_data_found then
1360: NULL;

Line 1357: and mtl_system_items.organization_id = p_organization_id;

1353: select primary_unit_of_measure
1354: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1355: from mtl_system_items
1356: where mtl_system_items.inventory_item_id = p_item_id
1357: and mtl_system_items.organization_id = p_organization_id;
1358: EXCEPTION
1359: when no_data_found then
1360: NULL;
1361: END;

Line 1754: MTL_SYSTEM_ITEMS MSI,

1750: NULL TASK_ID
1751: FROM
1752: OE_ORDER_LINES_all OEL,
1753: OE_ORDER_HEADERS_all OEH,
1754: MTL_SYSTEM_ITEMS MSI,
1755: MTL_UNITS_OF_MEASURE MUM
1756: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
1757: AND OEL.HEADER_ID = OEH.HEADER_ID
1758: AND OEL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 1813: from mtl_system_items

1809:
1810: BEGIN
1811: select primary_unit_of_measure
1812: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1813: from mtl_system_items
1814: where mtl_system_items.inventory_item_id = p_item_id
1815: and mtl_system_items.organization_id = p_organization_id;
1816: EXCEPTION
1817: when no_data_found then

Line 1814: where mtl_system_items.inventory_item_id = p_item_id

1810: BEGIN
1811: select primary_unit_of_measure
1812: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1813: from mtl_system_items
1814: where mtl_system_items.inventory_item_id = p_item_id
1815: and mtl_system_items.organization_id = p_organization_id;
1816: EXCEPTION
1817: when no_data_found then
1818: NULL;

Line 1815: and mtl_system_items.organization_id = p_organization_id;

1811: select primary_unit_of_measure
1812: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1813: from mtl_system_items
1814: where mtl_system_items.inventory_item_id = p_item_id
1815: and mtl_system_items.organization_id = p_organization_id;
1816: EXCEPTION
1817: when no_data_found then
1818: NULL;
1819: END;

Line 2191: MTL_SYSTEM_ITEMS MSI,

2187: PO_HEADERS POH,
2188: PO_LINE_LOCATIONS POLL,
2189: PO_LINES POL,
2190: PO_RELEASES POR,
2191: MTL_SYSTEM_ITEMS MSI,
2192: MTL_UNITS_OF_MEASURE MUM,
2193: PO_DISTRIBUTIONS POD
2194: WHERE
2195: POD.PO_DISTRIBUTION_ID = v_po_distribution_id

Line 2352: MTL_SYSTEM_ITEMS MSI,

2348: RCV_SHIPMENT_HEADERS RSH,
2349: RCV_SHIPMENT_LINES RSL,
2350: PO_REQUISITION_HEADERS PORH,
2351: PO_REQUISITION_LINES PORL,
2352: MTL_SYSTEM_ITEMS MSI,
2353: MTL_SYSTEM_ITEMS MSI1,
2354: MTL_UNITS_OF_MEASURE MUM
2355: WHERE
2356: RSH.RECEIPT_SOURCE_CODE <> 'VENDOR'

Line 2353: MTL_SYSTEM_ITEMS MSI1,

2349: RCV_SHIPMENT_LINES RSL,
2350: PO_REQUISITION_HEADERS PORH,
2351: PO_REQUISITION_LINES PORL,
2352: MTL_SYSTEM_ITEMS MSI,
2353: MTL_SYSTEM_ITEMS MSI1,
2354: MTL_UNITS_OF_MEASURE MUM
2355: WHERE
2356: RSH.RECEIPT_SOURCE_CODE <> 'VENDOR'
2357: AND RSL.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID(+)

Line 2461: FROM mtl_system_items

2457:
2458: IF p_item_id IS NOT NULL THEN
2459: SELECT primary_unit_of_measure
2460: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2461: FROM mtl_system_items
2462: WHERE mtl_system_items.inventory_item_id = p_item_id
2463: AND mtl_system_items.organization_id = p_organization_id;
2464: l_progress := '70';
2465: ELSE

Line 2462: WHERE mtl_system_items.inventory_item_id = p_item_id

2458: IF p_item_id IS NOT NULL THEN
2459: SELECT primary_unit_of_measure
2460: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2461: FROM mtl_system_items
2462: WHERE mtl_system_items.inventory_item_id = p_item_id
2463: AND mtl_system_items.organization_id = p_organization_id;
2464: l_progress := '70';
2465: ELSE
2466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;

Line 2463: AND mtl_system_items.organization_id = p_organization_id;

2459: SELECT primary_unit_of_measure
2460: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2461: FROM mtl_system_items
2462: WHERE mtl_system_items.inventory_item_id = p_item_id
2463: AND mtl_system_items.organization_id = p_organization_id;
2464: l_progress := '70';
2465: ELSE
2466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
2467: l_progress := '71';

Line 2801: , mtl_system_items msi

2797: wlpnc.lot_number,
2798: wlpnc.source_line_id
2799: FROM wms_lpn_contents wlpnc
2800: , wms_license_plate_numbers wlpn
2801: , mtl_system_items msi
2802: , rcv_shipment_headers rsh
2803: WHERE rsh.shipment_header_id = p_shipment_header_id
2804: AND (wlpn.source_header_id = rsh.shipment_header_id
2805: OR wlpn.source_name = rsh.shipment_num)