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.INV_RCV_STD_RCPT_APIS dependencies on MTL_SYSTEM_ITEMS

Line 195: l_po_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE; --bug 4697949

191: t_sec_uom VARCHAR2(25); t_sec_qty NUMBER;
192:
193: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
194:
195: l_po_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE; --bug 4697949
196: l_substitute_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE; --bug 4697949
197:
198: -- For Bug 7440217
199: v_lcm_enabled_org varchar2(1) := 'N';

Line 196: l_substitute_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE; --bug 4697949

192:
193: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
194:
195: l_po_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE; --bug 4697949
196: l_substitute_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE; --bug 4697949
197:
198: -- For Bug 7440217
199: v_lcm_enabled_org varchar2(1) := 'N';
200: v_pre_receive varchar2(1) := 'N';

Line 1342: FROM mtl_system_items_kfv

1338: END IF;
1339:
1340: SELECT primary_uom_code
1341: INTO l_primary_uom
1342: FROM mtl_system_items_kfv
1343: WHERE inventory_item_id = p_item_id
1344: AND organization_id = p_org_id;
1345:
1346: IF (l_debug = 1) THEN

Line 1712: , mtl_system_items msi

1708: FROM po_headers poh
1709: , po_line_locations poll
1710: , po_lines pol
1711: , po_releases por
1712: , mtl_system_items msi
1713: , mtl_units_of_measure mum
1714: WHERE poll.line_location_id = v_po_line_location_id
1715: AND poh.po_header_id = poll.po_header_id
1716: AND pol.po_line_id = poll.po_line_id

Line 1857: FROM mtl_system_items

1853: IF p_item_id IS NOT NULL THEN
1854: BEGIN
1855: SELECT primary_unit_of_measure
1856: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
1857: FROM mtl_system_items
1858: WHERE mtl_system_items.inventory_item_id = p_item_id
1859: AND mtl_system_items.organization_id = p_organization_id;
1860: EXCEPTION
1861: WHEN OTHERS THEN

Line 1858: WHERE mtl_system_items.inventory_item_id = p_item_id

1854: BEGIN
1855: SELECT primary_unit_of_measure
1856: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
1857: FROM mtl_system_items
1858: WHERE mtl_system_items.inventory_item_id = p_item_id
1859: AND mtl_system_items.organization_id = p_organization_id;
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: IF (l_debug = 1) THEN

Line 1859: AND mtl_system_items.organization_id = p_organization_id;

1855: SELECT primary_unit_of_measure
1856: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
1857: FROM mtl_system_items
1858: WHERE mtl_system_items.inventory_item_id = p_item_id
1859: AND mtl_system_items.organization_id = p_organization_id;
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: IF (l_debug = 1) THEN
1863: print_debug('Primary_uom is null should not be null', 4);

Line 2651: , mtl_system_items msi

2647: FROM rcv_shipment_headers rsh
2648: , rcv_shipment_lines rsl
2649: , po_requisition_headers porh
2650: , po_requisition_lines porl
2651: , mtl_system_items msi
2652: , mtl_system_items msi1
2653: , mtl_units_of_measure mum
2654: WHERE rsh.receipt_source_code <> 'VENDOR'
2655: AND rsl.requisition_line_id = porl.requisition_line_id(+)

Line 2652: , mtl_system_items msi1

2648: , rcv_shipment_lines rsl
2649: , po_requisition_headers porh
2650: , po_requisition_lines porl
2651: , mtl_system_items msi
2652: , mtl_system_items msi1
2653: , mtl_units_of_measure mum
2654: WHERE rsh.receipt_source_code <> 'VENDOR'
2655: AND rsl.requisition_line_id = porl.requisition_line_id(+)
2656: AND porl.requisition_header_id = porh.requisition_header_id(+)

Line 2793: FROM mtl_system_items

2789: l_progress := '60';
2790:
2791: SELECT primary_unit_of_measure
2792: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
2793: FROM mtl_system_items
2794: WHERE mtl_system_items.inventory_item_id = p_item_id
2795: AND mtl_system_items.organization_id = p_organization_id;
2796:
2797: l_progress := '70';

Line 2794: WHERE mtl_system_items.inventory_item_id = p_item_id

2790:
2791: SELECT primary_unit_of_measure
2792: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
2793: FROM mtl_system_items
2794: WHERE mtl_system_items.inventory_item_id = p_item_id
2795: AND mtl_system_items.organization_id = p_organization_id;
2796:
2797: l_progress := '70';
2798:

Line 2795: AND mtl_system_items.organization_id = p_organization_id;

2791: SELECT primary_unit_of_measure
2792: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
2793: FROM mtl_system_items
2794: WHERE mtl_system_items.inventory_item_id = p_item_id
2795: AND mtl_system_items.organization_id = p_organization_id;
2796:
2797: l_progress := '70';
2798:
2799: IF (l_debug = 1) THEN

Line 3328: , mtl_system_items msi

3324: , NULL secondary_uom_code --OPM Convergence
3325: , NULL secondary_quantity --OPM Convergence
3326: FROM oe_order_lines_all oel
3327: , oe_order_headers_all oeh
3328: , mtl_system_items msi
3329: , mtl_units_of_measure mum
3330: WHERE oel.line_category_code = 'RETURN'
3331: AND oel.header_id = oeh.header_id
3332: AND oel.inventory_item_id = msi.inventory_item_id

Line 3416: FROM mtl_system_items

3412: l_progress := '60';
3413:
3414: SELECT primary_unit_of_measure
3415: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
3416: FROM mtl_system_items
3417: WHERE mtl_system_items.inventory_item_id = p_item_id
3418: AND mtl_system_items.organization_id = p_organization_id;
3419:
3420: l_progress := '70';

Line 3417: WHERE mtl_system_items.inventory_item_id = p_item_id

3413:
3414: SELECT primary_unit_of_measure
3415: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
3416: FROM mtl_system_items
3417: WHERE mtl_system_items.inventory_item_id = p_item_id
3418: AND mtl_system_items.organization_id = p_organization_id;
3419:
3420: l_progress := '70';
3421:

Line 3418: AND mtl_system_items.organization_id = p_organization_id;

3414: SELECT primary_unit_of_measure
3415: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
3416: FROM mtl_system_items
3417: WHERE mtl_system_items.inventory_item_id = p_item_id
3418: AND mtl_system_items.organization_id = p_organization_id;
3419:
3420: l_progress := '70';
3421:
3422: IF (l_debug = 1) THEN

Line 3924: , mtl_system_items msi

3920: , po_headers poh
3921: , po_line_locations poll
3922: , po_lines pol
3923: , po_releases por
3924: , mtl_system_items msi
3925: , mtl_units_of_measure mum
3926: WHERE NVL(poll.approved_flag, 'N') = 'Y'
3927: AND NVL(poll.cancel_flag, 'N') = 'N'
3928: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 4094: , mtl_system_items msi

4090: FROM rcv_shipment_headers rsh
4091: , rcv_shipment_lines rsl
4092: , po_requisition_headers porh
4093: , po_requisition_lines porl
4094: , mtl_system_items msi
4095: , mtl_system_items msi1
4096: , mtl_units_of_measure mum
4097: WHERE rsh.receipt_source_code <> 'VENDOR'
4098: AND rsl.requisition_line_id = porl.requisition_line_id(+)

Line 4095: , mtl_system_items msi1

4091: , rcv_shipment_lines rsl
4092: , po_requisition_headers porh
4093: , po_requisition_lines porl
4094: , mtl_system_items msi
4095: , mtl_system_items msi1
4096: , mtl_units_of_measure mum
4097: WHERE rsh.receipt_source_code <> 'VENDOR'
4098: AND rsl.requisition_line_id = porl.requisition_line_id(+)
4099: AND porl.requisition_header_id = porh.requisition_header_id(+)

Line 4233: FROM mtl_system_items

4229: IF p_item_id IS NOT NULL THEN
4230: BEGIN
4231: SELECT primary_unit_of_measure
4232: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
4233: FROM mtl_system_items
4234: WHERE mtl_system_items.inventory_item_id = p_item_id
4235: AND mtl_system_items.organization_id = p_organization_id;
4236: EXCEPTION
4237: WHEN OTHERS THEN

Line 4234: WHERE mtl_system_items.inventory_item_id = p_item_id

4230: BEGIN
4231: SELECT primary_unit_of_measure
4232: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
4233: FROM mtl_system_items
4234: WHERE mtl_system_items.inventory_item_id = p_item_id
4235: AND mtl_system_items.organization_id = p_organization_id;
4236: EXCEPTION
4237: WHEN OTHERS THEN
4238: IF (l_debug = 1) THEN

Line 4235: AND mtl_system_items.organization_id = p_organization_id;

4231: SELECT primary_unit_of_measure
4232: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
4233: FROM mtl_system_items
4234: WHERE mtl_system_items.inventory_item_id = p_item_id
4235: AND mtl_system_items.organization_id = p_organization_id;
4236: EXCEPTION
4237: WHEN OTHERS THEN
4238: IF (l_debug = 1) THEN
4239: print_debug('Primary_uom is null should not be null', 4);

Line 4850: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh

4846: , lpnc.lot_number
4847: , lpn.organization_id
4848: , msi.serial_number_control_code
4849: , msi.primary_uom_code
4850: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh
4851: WHERE rsh.shipment_header_id = p_shipment_header_id
4852: AND(lpn.source_header_id = rsh.shipment_header_id
4853: OR lpn.source_name = rsh.shipment_num)
4854: AND lpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones

Line 4918: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;

4914: l_transaction_interface_id NUMBER;
4915: l_product_transaction_id NUMBER;
4916: l_serial_transaction_temp_id NUMBER;
4917: l_serial_number mtl_serial_numbers.serial_number%type;
4918: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
4919: l_lot_prm_quantity NUMBER; --lot quantity in primary uom
4920: l_lot_status_id NUMBER;
4921: l_serial_status_id NUMBER;
4922: l_from_org_id NUMBER;

Line 6198: , mtl_system_items msi

6194: FROM mtl_material_transactions mmt
6195: , mtl_transaction_lot_numbers mtln
6196: , rcv_transactions rt
6197: , rcv_shipment_lines rsl
6198: , mtl_system_items msi
6199: WHERE rt.interface_transaction_id = p_txn_source_id
6200: AND mmt.rcv_transaction_id = rt.transaction_id
6201: AND mmt.transaction_id = mtln.transaction_id
6202: AND(rt.transaction_type = 'RETURN TO RECEIVING'

Line 8588: , mtl_system_items msi1

8584: SELECT 1
8585: INTO l_lot_serial_flag
8586: FROM rcv_shipment_lines rsl
8587: , rcv_shipment_headers rsh
8588: , mtl_system_items msi1
8589: , mtl_system_items msi2
8590: WHERE rsh.shipment_num = p_shipment_number
8591: AND rsl.shipment_header_id = rsh.shipment_header_id
8592: AND rsl.item_id = msi1.inventory_item_id

Line 8589: , mtl_system_items msi2

8585: INTO l_lot_serial_flag
8586: FROM rcv_shipment_lines rsl
8587: , rcv_shipment_headers rsh
8588: , mtl_system_items msi1
8589: , mtl_system_items msi2
8590: WHERE rsh.shipment_num = p_shipment_number
8591: AND rsl.shipment_header_id = rsh.shipment_header_id
8592: AND rsl.item_id = msi1.inventory_item_id
8593: AND msi1.organization_id = p_from_organization_id

Line 8681: , mtl_system_items msi1

8677: SELECT 1
8678: INTO l_lot_serial_flag
8679: FROM rcv_shipment_lines rsl
8680: , rcv_shipment_headers rsh
8681: , mtl_system_items msi1
8682: , mtl_system_items msi2
8683: WHERE rsh.shipment_header_id = p_shipment_header_id
8684: AND rsl.shipment_header_id = rsh.shipment_header_id
8685: AND rsl.item_id = msi1.inventory_item_id

Line 8682: , mtl_system_items msi2

8678: INTO l_lot_serial_flag
8679: FROM rcv_shipment_lines rsl
8680: , rcv_shipment_headers rsh
8681: , mtl_system_items msi1
8682: , mtl_system_items msi2
8683: WHERE rsh.shipment_header_id = p_shipment_header_id
8684: AND rsl.shipment_header_id = rsh.shipment_header_id
8685: AND rsl.item_id = msi1.inventory_item_id
8686: AND msi1.organization_id = rsl.from_organization_id

Line 8902: , mtl_system_items msi1

8898: INTO l_lpn_flag
8899: FROM po_requisition_headers prh
8900: , po_requisition_lines prl
8901: , rcv_shipment_lines rsl
8902: , mtl_system_items msi1
8903: , mtl_system_items msi2
8904: WHERE prh.segment1 = p_req_num
8905: AND prl.requisition_header_id = prh.requisition_header_id
8906: AND rsl.requisition_line_id = prl.requisition_line_id

Line 8903: , mtl_system_items msi2

8899: FROM po_requisition_headers prh
8900: , po_requisition_lines prl
8901: , rcv_shipment_lines rsl
8902: , mtl_system_items msi1
8903: , mtl_system_items msi2
8904: WHERE prh.segment1 = p_req_num
8905: AND prl.requisition_header_id = prh.requisition_header_id
8906: AND rsl.requisition_line_id = prl.requisition_line_id
8907: AND rsl.item_id = msi1.inventory_item_id

Line 9003: FROM mtl_system_items

8999:
9000: BEGIN
9001: SELECT lot_control_code
9002: INTO l_lot_code
9003: FROM mtl_system_items
9004: WHERE inventory_item_id = l_item_id
9005: AND organization_id = p_organization_id;
9006:
9007: print_debug('item id ' || l_item_id || ' lot code ' || l_lot_code );

Line 9033: FROM mtl_system_items

9029: l_progress := '25';
9030:
9031: SELECT serial_number_control_code
9032: INTO l_serial_code
9033: FROM mtl_system_items
9034: WHERE organization_id = p_organization_id
9035: AND inventory_item_id = l_item_id;
9036:
9037: IF l_serial_code IN(2, 5) THEN