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 1645: FROM MTL_SYSTEM_ITEMS

1641:
1642: -- Get the item primary uom code
1643: SELECT primary_uom_code
1644: INTO l_primary_uom
1645: FROM MTL_SYSTEM_ITEMS
1646: WHERE inventory_item_id = g_cc_entry.inventory_item_id
1647: AND organization_id = g_cc_entry.organization_id;
1648:
1649: -- Convert the count quantity into the item primary uom quantity

Line 1901: FROM MTL_SYSTEM_ITEMS

1897:
1898: -- Get the item primary uom code
1899: SELECT primary_uom_code
1900: INTO l_primary_uom
1901: FROM MTL_SYSTEM_ITEMS
1902: WHERE inventory_item_id = g_cc_entry.inventory_item_id
1903: AND organization_id = g_cc_entry.organization_id;
1904:
1905: -- Convert the system quantity into the count uom

Line 2228: FROM mtl_system_items

2224:
2225: -- Bug 5186993
2226: SELECT serial_number_control_code
2227: INTO l_serial_number_ctrl_code
2228: FROM mtl_system_items
2229: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2230: AND organization_id = g_cc_entry.organization_id;
2231:
2232:

Line 2330: FROM mtl_system_items

2326:
2327: -- Get the required variable values
2328: SELECT serial_number_control_code
2329: INTO l_serial_number_ctrl_code
2330: FROM mtl_system_items
2331: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2332: AND organization_id = g_cc_entry.organization_id;
2333:
2334: SELECT NVL ( serial_detail_option, 1 ),

Line 2384: FROM MTL_SYSTEM_ITEMS

2380:
2381: -- Get the item primary uom code
2382: SELECT primary_uom_code
2383: INTO l_primary_uom
2384: FROM MTL_SYSTEM_ITEMS
2385: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2386: AND organization_id = g_cc_entry.organization_id;
2387:
2388: -- Convert the system quantity into the count uom

Line 2476: FROM MTL_SYSTEM_ITEMS

2472:
2473: -- Get the item primary uom code
2474: SELECT primary_uom_code
2475: INTO l_primary_uom
2476: FROM MTL_SYSTEM_ITEMS
2477: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2478: AND organization_id = g_cc_entry.organization_id;
2479:
2480: -- Convert the system quantity into the count uom

Line 2573: FROM MTL_SYSTEM_ITEMS

2569:
2570: -- Get the item primary uom code
2571: SELECT primary_uom_code
2572: INTO l_primary_uom
2573: FROM MTL_SYSTEM_ITEMS
2574: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2575: AND organization_id = g_cc_entry.organization_id;
2576:
2577: -- Convert the system quantity into the count uom

Line 2731: FROM mtl_system_items

2727:
2728: -- Get the required variable values
2729: SELECT serial_number_control_code
2730: INTO l_serial_number_ctrl_code
2731: FROM mtl_system_items
2732: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2733: AND organization_id = g_cc_entry.organization_id;
2734:
2735: SELECT NVL ( serial_detail_option, 1 ),

Line 2774: FROM MTL_SYSTEM_ITEMS

2770:
2771: -- Get the item primary uom code
2772: SELECT primary_uom_code
2773: INTO l_primary_uom
2774: FROM MTL_SYSTEM_ITEMS
2775: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2776: AND organization_id = g_cc_entry.organization_id;
2777:
2778: -- Convert the system quantity into the count uom

Line 2905: FROM MTL_SYSTEM_ITEMS

2901:
2902: -- Get the item primary uom code
2903: SELECT primary_uom_code
2904: INTO l_primary_uom
2905: FROM MTL_SYSTEM_ITEMS
2906: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2907: AND organization_id = g_cc_entry.organization_id;
2908:
2909: -- Convert the system quantity into the count uom

Line 2991: FROM MTL_SYSTEM_ITEMS

2987:
2988: -- Get the item primary uom code
2989: SELECT primary_uom_code
2990: INTO l_primary_uom
2991: FROM MTL_SYSTEM_ITEMS
2992: WHERE inventory_item_id = g_cc_entry.inventory_item_id
2993: AND organization_id = g_cc_entry.organization_id;
2994:
2995: -- Convert the system quantity into the count uom

Line 3159: FROM MTL_SYSTEM_ITEMS

3155: -- Get the required variable values
3156: -- Get the item primary uom code
3157: SELECT primary_uom_code
3158: INTO l_to_uom
3159: FROM MTL_SYSTEM_ITEMS
3160: WHERE inventory_item_id = g_cc_entry.inventory_item_id
3161: AND organization_id = g_cc_entry.organization_id;
3162:
3163: SELECT serial_number_control_code

Line 3165: FROM mtl_system_items

3161: AND organization_id = g_cc_entry.organization_id;
3162:
3163: SELECT serial_number_control_code
3164: INTO l_serial_number_ctrl_code
3165: FROM mtl_system_items
3166: WHERE inventory_item_id = g_cc_entry.inventory_item_id
3167: AND organization_id = g_cc_entry.organization_id;
3168:
3169: SELECT NVL ( serial_count_option, 1 ),

Line 3179: FROM mtl_system_items_kfv

3175: AND organization_id = g_cc_entry.organization_id;
3176:
3177: SELECT concatenated_segments
3178: INTO l_item_name
3179: FROM mtl_system_items_kfv
3180: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
3181:
3182: -- Bug 3296675, we need to delete cycle count reservations before checking for availability.
3183: IF ( l_entry_status_code = 5 ) THEN

Line 3216: FROM mtl_system_items

3212: revision_qty_control_code
3213: INTO v_ser_code,
3214: v_lot_code,
3215: v_rev_code
3216: FROM mtl_system_items
3217: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
3218:
3219: IF ( v_ser_code <> 1 ) THEN
3220: v_is_ser_controlled := TRUE;

Line 3645: FROM mtl_system_items

3641: FROM DUAL;
3642:
3643: SELECT auto_serial_alpha_prefix
3644: INTO l_serial_prefix
3645: FROM mtl_system_items
3646: WHERE inventory_item_id = l_item_id
3647: AND organization_id = l_org_id;
3648: END IF;
3649:

Line 4901: FROM MTL_SYSTEM_ITEMS

4897: -- Get the item primary uom code
4898: /* -- Bug 13652899
4899: SELECT primary_uom_code
4900: INTO l_to_uom
4901: FROM MTL_SYSTEM_ITEMS
4902: WHERE inventory_item_id = g_cc_entry.inventory_item_id
4903: AND organization_id = g_cc_entry.organization_id;
4904: */
4905:

Line 5290: FROM mtl_system_items

5286:
5287: -- Get the serial number control code
5288: SELECT serial_number_control_code
5289: INTO l_serial_number_control_code
5290: FROM mtl_system_items
5291: WHERE inventory_item_id = g_cc_entry.inventory_item_id
5292: AND organization_id = g_cc_entry.organization_id;
5293:
5294: -- Get the item system quantity

Line 6211: FROM mtl_system_items

6207:
6208: -- Get the serial number control code
6209: SELECT serial_number_control_code
6210: INTO l_serial_number_control_code
6211: FROM mtl_system_items
6212: WHERE inventory_item_id = g_cc_entry.inventory_item_id
6213: AND organization_id = g_cc_entry.organization_id;
6214:
6215: -- Get the item system quantity

Line 6513: FROM MTL_SYSTEM_ITEMS

6509:
6510: -- Get the item primary uom code
6511: SELECT primary_uom_code
6512: INTO l_to_uom
6513: FROM MTL_SYSTEM_ITEMS
6514: WHERE inventory_item_id = g_cc_entry.inventory_item_id
6515: AND organization_id = g_cc_entry.organization_id;
6516:
6517: -- Get the cycle count header inventory adjustment account

Line 6526: FROM mtl_system_items_kfv

6522: AND organization_id = g_cc_entry.organization_id;
6523:
6524: SELECT concatenated_segments
6525: INTO l_item_name
6526: FROM mtl_system_items_kfv
6527: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
6528:
6529: l_from_uom := g_count_uom;
6530: l_txn_uom := l_from_uom;

Line 6579: FROM mtl_system_items

6575: FROM DUAL;
6576:
6577: SELECT auto_serial_alpha_prefix
6578: INTO l_serial_prefix
6579: FROM mtl_system_items
6580: WHERE inventory_item_id = l_item_id AND organization_id = l_org_id;
6581:
6582: l_p_uom_qty :=
6583: inv_convert.inv_um_convert ( l_item_id,

Line 6620: FROM mtl_system_items

6616: revision_qty_control_code
6617: INTO v_ser_code,
6618: v_lot_code,
6619: v_rev_code
6620: FROM mtl_system_items
6621: WHERE inventory_item_id = l_item_id
6622: AND organization_id = l_org_id;
6623:
6624: IF ( v_ser_code <> 1 ) THEN

Line 7089: FROM mtl_system_items

7085:
7086: -- Get the required values
7087: SELECT serial_number_control_code
7088: INTO l_serial_number_ctrl_code
7089: FROM mtl_system_items
7090: WHERE inventory_item_id = g_cc_entry.inventory_item_id
7091: AND organization_id = g_cc_entry.organization_id;
7092:
7093: SELECT NVL ( serial_count_option, 1 )

Line 7194: FROM mtl_system_items

7190:
7191: -- Get the required values
7192: SELECT serial_number_control_code
7193: INTO l_serial_number_ctrl_code
7194: FROM mtl_system_items
7195: WHERE inventory_item_id = g_cc_entry.inventory_item_id
7196: AND organization_id = g_cc_entry.organization_id;
7197:
7198: SELECT NVL ( serial_count_option, 1 )

Line 7518: FROM mtl_system_items

7514: IF ( l_temp_count <> 0 ) THEN
7515: -- Get the primary UOM for the container inventory item
7516: SELECT primary_uom_code
7517: INTO l_temp_uom_code
7518: FROM mtl_system_items
7519: WHERE inventory_item_id = v_lpn_id.inventory_item_id
7520: AND organization_id = v_lpn_id.organization_id;
7521:
7522: IF ( l_debug = 1 ) THEN

Line 7613: FROM mtl_system_items

7609: IF ( l_temp_count <> 0 ) THEN
7610: /* Get the primary UOM for the serialized item */
7611: SELECT primary_uom_code
7612: INTO l_temp_uom_code
7613: FROM mtl_system_items
7614: WHERE inventory_item_id =
7615: v_lpn_serial_content.inventory_item_id
7616: AND organization_id =
7617: v_lpn_serial_content.current_organization_id;

Line 8141: FROM mtl_system_items

8137: g_count_quantity := tmp_count;
8138:
8139: SELECT primary_uom_code
8140: INTO g_count_uom
8141: FROM mtl_system_items
8142: WHERE inventory_item_id = g_cc_entry.inventory_item_id
8143: AND organization_id = g_cc_entry.organization_id;
8144:
8145: -- Get the serial adjustment option for the cycle count header

Line 9079: FROM mtl_system_items

9075: SELECT primary_uom_code,
9076: serial_number_control_code
9077: INTO l_primary_uom,
9078: l_serial_number_control_code
9079: FROM mtl_system_items
9080: WHERE inventory_item_id = p_inventory_item_id
9081: AND organization_id = p_organization_id;
9082:
9083: l_progress := '20';