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_CYC_LOVS dependencies on MTL_SYSTEM_ITEMS

Line 1409: FROM MTL_SYSTEM_ITEMS

1405:
1406: -- Get the item primary uom code
1407: SELECT primary_uom_code
1408: INTO l_primary_uom
1409: FROM MTL_SYSTEM_ITEMS
1410: WHERE inventory_item_id = g_cc_entry.inventory_item_id
1411: AND organization_id = g_cc_entry.organization_id;
1412:
1413: -- Convert the count quantity into the item primary uom quantity

Line 1665: FROM MTL_SYSTEM_ITEMS

1661:
1662: -- Get the item primary uom code
1663: SELECT primary_uom_code
1664: INTO l_primary_uom
1665: FROM MTL_SYSTEM_ITEMS
1666: WHERE inventory_item_id = g_cc_entry.inventory_item_id
1667: AND organization_id = g_cc_entry.organization_id;
1668:
1669: -- Convert the system quantity into the count uom

Line 1992: FROM mtl_system_items

1988:
1989: -- Bug 5186993
1990: SELECT serial_number_control_code
1991: INTO l_serial_number_ctrl_code
1992: FROM mtl_system_items
1993: WHERE inventory_item_id = g_cc_entry.inventory_item_id
1994: AND organization_id = g_cc_entry.organization_id;
1995:
1996:

Line 2094: FROM mtl_system_items

2090:
2091: -- Get the required variable values
2092: SELECT serial_number_control_code
2093: INTO l_serial_number_ctrl_code
2094: FROM mtl_system_items
2095: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2096: AND organization_id = g_cc_entry.organization_id;
2097:
2098: SELECT NVL ( serial_detail_option, 1 ),

Line 2137: FROM MTL_SYSTEM_ITEMS

2133:
2134: -- Get the item primary uom code
2135: SELECT primary_uom_code
2136: INTO l_primary_uom
2137: FROM MTL_SYSTEM_ITEMS
2138: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2139: AND organization_id = g_cc_entry.organization_id;
2140:
2141: -- Convert the system quantity into the count uom

Line 2229: FROM MTL_SYSTEM_ITEMS

2225:
2226: -- Get the item primary uom code
2227: SELECT primary_uom_code
2228: INTO l_primary_uom
2229: FROM MTL_SYSTEM_ITEMS
2230: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2231: AND organization_id = g_cc_entry.organization_id;
2232:
2233: -- Convert the system quantity into the count uom

Line 2326: FROM MTL_SYSTEM_ITEMS

2322:
2323: -- Get the item primary uom code
2324: SELECT primary_uom_code
2325: INTO l_primary_uom
2326: FROM MTL_SYSTEM_ITEMS
2327: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2328: AND organization_id = g_cc_entry.organization_id;
2329:
2330: -- Convert the system quantity into the count uom

Line 2484: FROM mtl_system_items

2480:
2481: -- Get the required variable values
2482: SELECT serial_number_control_code
2483: INTO l_serial_number_ctrl_code
2484: FROM mtl_system_items
2485: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2486: AND organization_id = g_cc_entry.organization_id;
2487:
2488: SELECT NVL ( serial_detail_option, 1 ),

Line 2527: FROM MTL_SYSTEM_ITEMS

2523:
2524: -- Get the item primary uom code
2525: SELECT primary_uom_code
2526: INTO l_primary_uom
2527: FROM MTL_SYSTEM_ITEMS
2528: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2529: AND organization_id = g_cc_entry.organization_id;
2530:
2531: -- Convert the system quantity into the count uom

Line 2658: FROM MTL_SYSTEM_ITEMS

2654:
2655: -- Get the item primary uom code
2656: SELECT primary_uom_code
2657: INTO l_primary_uom
2658: FROM MTL_SYSTEM_ITEMS
2659: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2660: AND organization_id = g_cc_entry.organization_id;
2661:
2662: -- Convert the system quantity into the count uom

Line 2744: FROM MTL_SYSTEM_ITEMS

2740:
2741: -- Get the item primary uom code
2742: SELECT primary_uom_code
2743: INTO l_primary_uom
2744: FROM MTL_SYSTEM_ITEMS
2745: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2746: AND organization_id = g_cc_entry.organization_id;
2747:
2748: -- Convert the system quantity into the count uom

Line 2908: FROM MTL_SYSTEM_ITEMS

2904: -- Get the required variable values
2905: -- Get the item primary uom code
2906: SELECT primary_uom_code
2907: INTO l_to_uom
2908: FROM MTL_SYSTEM_ITEMS
2909: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2910: AND organization_id = g_cc_entry.organization_id;
2911:
2912: SELECT serial_number_control_code

Line 2914: FROM mtl_system_items

2910: AND organization_id = g_cc_entry.organization_id;
2911:
2912: SELECT serial_number_control_code
2913: INTO l_serial_number_ctrl_code
2914: FROM mtl_system_items
2915: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2916: AND organization_id = g_cc_entry.organization_id;
2917:
2918: SELECT NVL ( serial_count_option, 1 ),

Line 2928: FROM mtl_system_items_kfv

2924: AND organization_id = g_cc_entry.organization_id;
2925:
2926: SELECT concatenated_segments
2927: INTO l_item_name
2928: FROM mtl_system_items_kfv
2929: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
2930:
2931: -- Bug 3296675, we need to delete cycle count reservations before checking for availability.
2932: IF ( l_entry_status_code = 5 ) THEN

Line 2965: FROM mtl_system_items

2961: revision_qty_control_code
2962: INTO v_ser_code,
2963: v_lot_code,
2964: v_rev_code
2965: FROM mtl_system_items
2966: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
2967:
2968: IF ( v_ser_code <> 1 ) THEN
2969: v_is_ser_controlled := TRUE;

Line 3348: FROM mtl_system_items

3344: FROM DUAL;
3345:
3346: SELECT auto_serial_alpha_prefix
3347: INTO l_serial_prefix
3348: FROM mtl_system_items
3349: WHERE inventory_item_id = l_item_id
3350: AND organization_id = l_org_id;
3351: END IF;
3352:

Line 4286: FROM mtl_system_items

4282: SELECT primary_uom_code,
4283: serial_number_control_code
4284: INTO l_from_uom,
4285: l_serial_number_control_code
4286: FROM mtl_system_items
4287: WHERE inventory_item_id = g_cc_entry.inventory_item_id
4288: AND organization_id = g_cc_entry.organization_id;
4289:
4290: SELECT NVL ( serial_count_option, 1 )

Line 4615: FROM mtl_system_items

4611: SELECT primary_uom_code,
4612: serial_number_control_code
4613: INTO l_from_uom,
4614: l_serial_number_control_code
4615: FROM mtl_system_items
4616: WHERE inventory_item_id = g_cc_entry.inventory_item_id
4617: AND organization_id = g_cc_entry.organization_id;
4618:
4619: SELECT NVL ( serial_count_option, 1 )

Line 4898: FROM MTL_SYSTEM_ITEMS

4894:
4895: -- Get the item primary uom code
4896: SELECT primary_uom_code
4897: INTO l_to_uom
4898: FROM MTL_SYSTEM_ITEMS
4899: WHERE inventory_item_id = g_cc_entry.inventory_item_id
4900: AND organization_id = g_cc_entry.organization_id;
4901:
4902: -- Convert the system quantity into the count uom

Line 5086: FROM mtl_system_items

5082: */
5083: IF p_lpn_id IS NULL THEN
5084: SELECT lot_control_code
5085: INTO l_lot_control_code
5086: FROM mtl_system_items
5087: WHERE organization_id = p_organization_id
5088: AND inventory_item_id = p_inventory_item_id;
5089:
5090: IF l_lot_control_code = 1 THEN -- no lot control code

Line 5191: FROM mtl_system_items

5187:
5188: -- Get the serial number control code
5189: SELECT serial_number_control_code
5190: INTO l_serial_number_control_code
5191: FROM mtl_system_items
5192: WHERE inventory_item_id = g_cc_entry.inventory_item_id
5193: AND organization_id = g_cc_entry.organization_id;
5194:
5195: -- Get the item system quantity

Line 5707: FROM MTL_SYSTEM_ITEMS

5703:
5704: -- Get the item primary uom code
5705: SELECT primary_uom_code
5706: INTO l_primary_uom
5707: FROM MTL_SYSTEM_ITEMS
5708: WHERE inventory_item_id = g_cc_entry.inventory_item_id
5709: AND organization_id = g_cc_entry.organization_id;
5710:
5711: IF ( l_debug = 1 ) THEN

Line 6105: FROM mtl_system_items

6101:
6102: -- Get the serial number control code
6103: SELECT serial_number_control_code
6104: INTO l_serial_number_control_code
6105: FROM mtl_system_items
6106: WHERE inventory_item_id = g_cc_entry.inventory_item_id
6107: AND organization_id = g_cc_entry.organization_id;
6108:
6109: -- Get the item system quantity

Line 6407: FROM MTL_SYSTEM_ITEMS

6403:
6404: -- Get the item primary uom code
6405: SELECT primary_uom_code
6406: INTO l_to_uom
6407: FROM MTL_SYSTEM_ITEMS
6408: WHERE inventory_item_id = g_cc_entry.inventory_item_id
6409: AND organization_id = g_cc_entry.organization_id;
6410:
6411: -- Get the cycle count header inventory adjustment account

Line 6420: FROM mtl_system_items_kfv

6416: AND organization_id = g_cc_entry.organization_id;
6417:
6418: SELECT concatenated_segments
6419: INTO l_item_name
6420: FROM mtl_system_items_kfv
6421: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
6422:
6423: l_from_uom := g_count_uom;
6424: l_txn_uom := l_from_uom;

Line 6473: FROM mtl_system_items

6469: FROM DUAL;
6470:
6471: SELECT auto_serial_alpha_prefix
6472: INTO l_serial_prefix
6473: FROM mtl_system_items
6474: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
6475:
6476: l_p_uom_qty :=
6477: inv_convert.inv_um_convert ( l_item_id,

Line 6514: FROM mtl_system_items

6510: revision_qty_control_code
6511: INTO v_ser_code,
6512: v_lot_code,
6513: v_rev_code
6514: FROM mtl_system_items
6515: WHERE inventory_item_id = l_item_id
6516: AND organization_id = l_org_id;
6517:
6518: IF ( v_ser_code <> 1 ) THEN

Line 6980: FROM mtl_system_items

6976:
6977: -- Get the required values
6978: SELECT serial_number_control_code
6979: INTO l_serial_number_ctrl_code
6980: FROM mtl_system_items
6981: WHERE inventory_item_id = g_cc_entry.inventory_item_id
6982: AND organization_id = g_cc_entry.organization_id;
6983:
6984: SELECT NVL ( serial_count_option, 1 )

Line 7085: FROM mtl_system_items

7081:
7082: -- Get the required values
7083: SELECT serial_number_control_code
7084: INTO l_serial_number_ctrl_code
7085: FROM mtl_system_items
7086: WHERE inventory_item_id = g_cc_entry.inventory_item_id
7087: AND organization_id = g_cc_entry.organization_id;
7088:
7089: SELECT NVL ( serial_count_option, 1 )

Line 7329: FROM mtl_system_items

7325: IF ( l_temp_count <> 0 ) THEN
7326: /* Get the primary UOM for the container inventory item */
7327: SELECT primary_uom_code
7328: INTO l_temp_uom_code
7329: FROM mtl_system_items
7330: WHERE inventory_item_id = v_lpn_id.inventory_item_id
7331: AND organization_id = v_lpn_id.organization_id;
7332:
7333: IF ( l_debug = 1 ) THEN

Line 7424: FROM mtl_system_items

7420: IF ( l_temp_count <> 0 ) THEN
7421: /* Get the primary UOM for the serialized item */
7422: SELECT primary_uom_code
7423: INTO l_temp_uom_code
7424: FROM mtl_system_items
7425: WHERE inventory_item_id =
7426: v_lpn_serial_content.inventory_item_id
7427: AND organization_id =
7428: v_lpn_serial_content.current_organization_id;

Line 7943: FROM mtl_system_items

7939: g_count_quantity := tmp_count;
7940:
7941: SELECT primary_uom_code
7942: INTO g_count_uom
7943: FROM mtl_system_items
7944: WHERE inventory_item_id = g_cc_entry.inventory_item_id
7945: AND organization_id = g_cc_entry.organization_id;
7946:
7947: -- Get the serial adjustment option for the cycle count header

Line 8854: FROM mtl_system_items

8850: SELECT primary_uom_code,
8851: serial_number_control_code
8852: INTO l_primary_uom,
8853: l_serial_number_control_code
8854: FROM mtl_system_items
8855: WHERE inventory_item_id = p_inventory_item_id
8856: AND organization_id = p_organization_id;
8857:
8858: l_progress := '20';