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 1384: FROM mtl_system_items_kfv

1380: END IF;
1381:
1382: SELECT primary_uom_code
1383: INTO l_primary_uom
1384: FROM mtl_system_items_kfv
1385: WHERE inventory_item_id = p_item_id
1386: AND organization_id = p_org_id;
1387:
1388: IF (l_debug = 1) THEN

Line 1761: , mtl_system_items msi

1757: FROM po_headers poh
1758: , po_line_locations poll
1759: , po_lines pol
1760: , po_releases por
1761: , mtl_system_items msi
1762: , mtl_units_of_measure mum
1763: WHERE poll.line_location_id = v_po_line_location_id
1764: AND poh.po_header_id = poll.po_header_id
1765: AND pol.po_line_id = poll.po_line_id

Line 1906: FROM mtl_system_items

1902: IF p_item_id IS NOT NULL THEN
1903: BEGIN
1904: SELECT primary_unit_of_measure
1905: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
1906: FROM mtl_system_items
1907: WHERE mtl_system_items.inventory_item_id = p_item_id
1908: AND mtl_system_items.organization_id = p_organization_id;
1909: EXCEPTION
1910: WHEN OTHERS THEN

Line 1907: WHERE mtl_system_items.inventory_item_id = p_item_id

1903: BEGIN
1904: SELECT primary_unit_of_measure
1905: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
1906: FROM mtl_system_items
1907: WHERE mtl_system_items.inventory_item_id = p_item_id
1908: AND mtl_system_items.organization_id = p_organization_id;
1909: EXCEPTION
1910: WHEN OTHERS THEN
1911: IF (l_debug = 1) THEN

Line 1908: AND mtl_system_items.organization_id = p_organization_id;

1904: SELECT primary_unit_of_measure
1905: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
1906: FROM mtl_system_items
1907: WHERE mtl_system_items.inventory_item_id = p_item_id
1908: AND mtl_system_items.organization_id = p_organization_id;
1909: EXCEPTION
1910: WHEN OTHERS THEN
1911: IF (l_debug = 1) THEN
1912: print_debug('Primary_uom is null should not be null', 4);

Line 2707: , mtl_system_items msi

2703: FROM rcv_shipment_headers rsh
2704: , rcv_shipment_lines rsl
2705: , po_requisition_headers porh
2706: , po_requisition_lines porl
2707: , mtl_system_items msi
2708: , mtl_system_items msi1
2709: , mtl_units_of_measure mum
2710: WHERE rsh.receipt_source_code <> 'VENDOR'
2711: AND rsl.requisition_line_id = porl.requisition_line_id(+)

Line 2708: , mtl_system_items msi1

2704: , rcv_shipment_lines rsl
2705: , po_requisition_headers porh
2706: , po_requisition_lines porl
2707: , mtl_system_items msi
2708: , mtl_system_items msi1
2709: , mtl_units_of_measure mum
2710: WHERE rsh.receipt_source_code <> 'VENDOR'
2711: AND rsl.requisition_line_id = porl.requisition_line_id(+)
2712: AND porl.requisition_header_id = porh.requisition_header_id(+)

Line 2880: FROM mtl_system_items_b

2876: --start part 2 bug 12814511
2877: BEGIN
2878: SELECT lot_control_code,serial_number_control_code
2879: INTO l2_lot_code,l_serial_control_code1
2880: FROM mtl_system_items_b
2881: WHERE inventory_item_id = p_item_id
2882: AND ORGANIZATION_id = (SELECT ORGANIZATION_id FROM
2883: rcv_shipment_headers WHERE SHIPMENT_HEADER_ID =p_shipment_header_id);--bug13558642
2884:

Line 2937: FROM mtl_system_items

2933: l_progress := '60';
2934:
2935: SELECT primary_unit_of_measure
2936: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
2937: FROM mtl_system_items
2938: WHERE mtl_system_items.inventory_item_id = p_item_id
2939: AND mtl_system_items.organization_id = p_organization_id;
2940:
2941: l_progress := '70';

Line 2938: WHERE mtl_system_items.inventory_item_id = p_item_id

2934:
2935: SELECT primary_unit_of_measure
2936: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
2937: FROM mtl_system_items
2938: WHERE mtl_system_items.inventory_item_id = p_item_id
2939: AND mtl_system_items.organization_id = p_organization_id;
2940:
2941: l_progress := '70';
2942:

Line 2939: AND mtl_system_items.organization_id = p_organization_id;

2935: SELECT primary_unit_of_measure
2936: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
2937: FROM mtl_system_items
2938: WHERE mtl_system_items.inventory_item_id = p_item_id
2939: AND mtl_system_items.organization_id = p_organization_id;
2940:
2941: l_progress := '70';
2942:
2943: IF (l_debug = 1) THEN

Line 3491: , mtl_system_items msi

3487: , NULL secondary_uom_code --OPM Convergence
3488: , NULL secondary_quantity --OPM Convergence
3489: FROM oe_order_lines_all oel
3490: , oe_order_headers_all oeh
3491: , mtl_system_items msi
3492: , mtl_units_of_measure mum
3493: WHERE oel.line_category_code = 'RETURN'
3494: AND oel.header_id = oeh.header_id
3495: AND oel.inventory_item_id = msi.inventory_item_id

Line 3579: FROM mtl_system_items

3575: l_progress := '60';
3576:
3577: SELECT primary_unit_of_measure
3578: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
3579: FROM mtl_system_items
3580: WHERE mtl_system_items.inventory_item_id = p_item_id
3581: AND mtl_system_items.organization_id = p_organization_id;
3582:
3583: l_progress := '70';

Line 3580: WHERE mtl_system_items.inventory_item_id = p_item_id

3576:
3577: SELECT primary_unit_of_measure
3578: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
3579: FROM mtl_system_items
3580: WHERE mtl_system_items.inventory_item_id = p_item_id
3581: AND mtl_system_items.organization_id = p_organization_id;
3582:
3583: l_progress := '70';
3584:

Line 3581: AND mtl_system_items.organization_id = p_organization_id;

3577: SELECT primary_unit_of_measure
3578: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
3579: FROM mtl_system_items
3580: WHERE mtl_system_items.inventory_item_id = p_item_id
3581: AND mtl_system_items.organization_id = p_organization_id;
3582:
3583: l_progress := '70';
3584:
3585: IF (l_debug = 1) THEN

Line 4105: , mtl_system_items msi

4101: , po_headers poh
4102: , po_line_locations poll
4103: , po_lines pol
4104: , po_releases por
4105: , mtl_system_items msi
4106: , mtl_units_of_measure mum
4107: WHERE NVL(poll.approved_flag, 'N') = 'Y'
4108: AND NVL(poll.cancel_flag, 'N') = 'N'
4109: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 4275: , mtl_system_items msi

4271: FROM rcv_shipment_headers rsh
4272: , rcv_shipment_lines rsl
4273: , po_requisition_headers porh
4274: , po_requisition_lines porl
4275: , mtl_system_items msi
4276: , mtl_system_items msi1
4277: , mtl_units_of_measure mum
4278: WHERE rsh.receipt_source_code <> 'VENDOR'
4279: AND rsl.requisition_line_id = porl.requisition_line_id(+)

Line 4276: , mtl_system_items msi1

4272: , rcv_shipment_lines rsl
4273: , po_requisition_headers porh
4274: , po_requisition_lines porl
4275: , mtl_system_items msi
4276: , mtl_system_items msi1
4277: , mtl_units_of_measure mum
4278: WHERE rsh.receipt_source_code <> 'VENDOR'
4279: AND rsl.requisition_line_id = porl.requisition_line_id(+)
4280: AND porl.requisition_header_id = porh.requisition_header_id(+)

Line 4489: FROM mtl_system_items

4485: IF p_item_id IS NOT NULL THEN
4486: BEGIN
4487: SELECT primary_unit_of_measure
4488: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
4489: FROM mtl_system_items
4490: WHERE mtl_system_items.inventory_item_id = p_item_id
4491: AND mtl_system_items.organization_id = p_organization_id;
4492: EXCEPTION
4493: WHEN OTHERS THEN

Line 4490: WHERE mtl_system_items.inventory_item_id = p_item_id

4486: BEGIN
4487: SELECT primary_unit_of_measure
4488: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
4489: FROM mtl_system_items
4490: WHERE mtl_system_items.inventory_item_id = p_item_id
4491: AND mtl_system_items.organization_id = p_organization_id;
4492: EXCEPTION
4493: WHEN OTHERS THEN
4494: IF (l_debug = 1) THEN

Line 4491: AND mtl_system_items.organization_id = p_organization_id;

4487: SELECT primary_unit_of_measure
4488: INTO g_rcpt_match_table_gross(g_receipt_detail_index).primary_unit_of_measure
4489: FROM mtl_system_items
4490: WHERE mtl_system_items.inventory_item_id = p_item_id
4491: AND mtl_system_items.organization_id = p_organization_id;
4492: EXCEPTION
4493: WHEN OTHERS THEN
4494: IF (l_debug = 1) THEN
4495: print_debug('Primary_uom is null should not be null', 4);

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

5114: , lpn.organization_id
5115: , msi.serial_number_control_code
5116: , msi.primary_uom_code
5117: , lpnc.secondary_quantity -- Bug 7708998
5118: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh
5119: WHERE rsh.shipment_header_id = p_shipment_header_id
5120: AND((lpn.source_header_id = rsh.shipment_header_id)
5121: OR (lpn.source_header_id IS NULL AND lpn.source_name = rsh.shipment_num)) --BUG14846625/16711363
5122: AND lpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones

Line 5186: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;

5182: l_transaction_interface_id NUMBER;
5183: l_product_transaction_id NUMBER;
5184: l_serial_transaction_temp_id NUMBER;
5185: l_serial_number mtl_serial_numbers.serial_number%type;
5186: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
5187: l_lot_prm_quantity NUMBER; --lot quantity in primary uom
5188: l_lot_status_id NUMBER;
5189: l_serial_status_id NUMBER;
5190: l_from_org_id NUMBER;

Line 6549: , mtl_system_items msi

6545: FROM mtl_material_transactions mmt
6546: , mtl_transaction_lot_numbers mtln
6547: , rcv_transactions rt
6548: , rcv_shipment_lines rsl
6549: , mtl_system_items msi
6550: WHERE rt.interface_transaction_id = p_txn_source_id
6551: AND mmt.rcv_transaction_id = rt.transaction_id
6552: AND mmt.transaction_id = mtln.transaction_id
6553: AND(rt.transaction_type = 'RETURN TO RECEIVING'

Line 8984: , mtl_system_items msi1

8980: SELECT 1
8981: INTO l_lot_serial_flag
8982: FROM rcv_shipment_lines rsl
8983: , rcv_shipment_headers rsh
8984: , mtl_system_items msi1
8985: , mtl_system_items msi2
8986: WHERE rsh.shipment_num = p_shipment_number
8987: AND rsl.shipment_header_id = rsh.shipment_header_id
8988: AND rsl.item_id = msi1.inventory_item_id

Line 8985: , mtl_system_items msi2

8981: INTO l_lot_serial_flag
8982: FROM rcv_shipment_lines rsl
8983: , rcv_shipment_headers rsh
8984: , mtl_system_items msi1
8985: , mtl_system_items msi2
8986: WHERE rsh.shipment_num = p_shipment_number
8987: AND rsl.shipment_header_id = rsh.shipment_header_id
8988: AND rsl.item_id = msi1.inventory_item_id
8989: AND msi1.organization_id = p_from_organization_id

Line 9077: , mtl_system_items msi1

9073: SELECT 1
9074: INTO l_lot_serial_flag
9075: FROM rcv_shipment_lines rsl
9076: , rcv_shipment_headers rsh
9077: , mtl_system_items msi1
9078: , mtl_system_items msi2
9079: WHERE rsh.shipment_header_id = p_shipment_header_id
9080: AND rsl.shipment_header_id = rsh.shipment_header_id
9081: AND rsl.item_id = msi1.inventory_item_id

Line 9078: , mtl_system_items msi2

9074: INTO l_lot_serial_flag
9075: FROM rcv_shipment_lines rsl
9076: , rcv_shipment_headers rsh
9077: , mtl_system_items msi1
9078: , mtl_system_items msi2
9079: WHERE rsh.shipment_header_id = p_shipment_header_id
9080: AND rsl.shipment_header_id = rsh.shipment_header_id
9081: AND rsl.item_id = msi1.inventory_item_id
9082: AND msi1.organization_id = rsl.from_organization_id

Line 9298: , mtl_system_items msi1

9294: INTO l_lpn_flag
9295: FROM po_requisition_headers prh
9296: , po_requisition_lines prl
9297: , rcv_shipment_lines rsl
9298: , mtl_system_items msi1
9299: , mtl_system_items msi2
9300: WHERE prh.segment1 = p_req_num
9301: AND prl.requisition_header_id = prh.requisition_header_id
9302: AND rsl.requisition_line_id = prl.requisition_line_id

Line 9299: , mtl_system_items msi2

9295: FROM po_requisition_headers prh
9296: , po_requisition_lines prl
9297: , rcv_shipment_lines rsl
9298: , mtl_system_items msi1
9299: , mtl_system_items msi2
9300: WHERE prh.segment1 = p_req_num
9301: AND prl.requisition_header_id = prh.requisition_header_id
9302: AND rsl.requisition_line_id = prl.requisition_line_id
9303: AND rsl.item_id = msi1.inventory_item_id

Line 9399: FROM mtl_system_items

9395:
9396: BEGIN
9397: SELECT lot_control_code
9398: INTO l_lot_code
9399: FROM mtl_system_items
9400: WHERE inventory_item_id = l_item_id
9401: AND organization_id = p_organization_id;
9402:
9403: print_debug('item id ' || l_item_id || ' lot code ' || l_lot_code );

Line 9429: FROM mtl_system_items

9425: l_progress := '25';
9426:
9427: SELECT serial_number_control_code
9428: INTO l_serial_code
9429: FROM mtl_system_items
9430: WHERE organization_id = p_organization_id
9431: AND inventory_item_id = l_item_id;
9432:
9433: IF l_serial_code IN(2, 5) THEN

Line 9760: FROM mtl_system_items_b

9756: --start bug 12814511
9757: BEGIN
9758: SELECT lot_control_code
9759: INTO l_lot_code
9760: FROM mtl_system_items_b
9761: WHERE inventory_item_id = p_inventory_item_id
9762: AND ORGANIZATION_id = (SELECT ORGANIZATION_id FROM
9763: rcv_shipment_headers WHERE SHIPMENT_HEADER_ID =p_shipment_header_id);
9764: IF (l_debug = 1) THEN