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_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 568: IF l_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

564: LOOP
565: FETCH status_attr_control INTO l_status_attr, l_status_ctrl;
566: EXIT when status_attr_control%NOTFOUND;
567:
568: IF l_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
569: l_bom_enabled_status := l_status_ctrl;
570: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
571: l_purchasable_status := l_status_ctrl;
572: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

Line 576: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

572: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
573: l_transactable_status := l_status_ctrl;
574: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
575: l_stockable_status := l_status_ctrl;
576: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
577: l_wip_status := l_status_ctrl;
578: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
579: l_cust_ord_status := l_status_ctrl;
580: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

Line 596: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

592: LOOP
593: FETCH status_attr_values INTO l_attr_name, l_attr_value;
594: EXIT when status_attr_values%NOTFOUND;
595:
596: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
597: l_bom_enabled_value := l_attr_value;
598: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
599: l_purchasable_value := l_attr_value;
600: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

Line 604: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN

600: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
601: l_transactable_value := l_attr_value;
602: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
603: l_stockable_value := l_attr_value;
604: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
605: l_wip_value := l_attr_value;
606: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
607: l_cust_ord_value := l_attr_value;
608: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

Line 3106: FROM MTL_SYSTEM_ITEMS_B_KFV MSI,

3102: l_sql_stmt := 'SELECT INVENTORY_ITEM_ID,
3103: ITEM_CATALOG_GROUP_ID,
3104: PRIMARY_UNIT_OF_MEASURE,
3105: DESCRIPTION
3106: FROM MTL_SYSTEM_ITEMS_B_KFV MSI,
3107: MTL_PARAMETERS P
3108: WHERE MSI.ORGANIZATION_ID = P.ORGANIZATION_ID ';
3109:
3110: get_segments_string(P_Segment_Rec => P_Segment_Rec

Line 3209: INSERT INTO MTL_SYSTEM_ITEMS_B(

3205: l_VENDOR_WARRANTY_FLAG := 'N';
3206: l_USAGE_ITEM_FLAG := NULL;
3207: END IF;
3208:
3209: INSERT INTO MTL_SYSTEM_ITEMS_B(
3210: DESCRIPTION,
3211: INVENTORY_ITEM_ID,
3212: ORGANIZATION_ID,
3213: SUMMARY_FLAG,

Line 4202: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS

4198: PROCEDURE check_mismatch_of_secuom_class(
4199: p_inventory_item_id IN NUMBER
4200: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4201: IS
4202: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4203: SELECT muomv.UOM_CLASS
4204: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib
4205: WHERE muomv.uom_code = msib.secondary_uom_code
4206: AND msib.inventory_item_id = Vinventory_item_id

Line 4204: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib

4200: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4201: IS
4202: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4203: SELECT muomv.UOM_CLASS
4204: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib
4205: WHERE muomv.uom_code = msib.secondary_uom_code
4206: AND msib.inventory_item_id = Vinventory_item_id
4207: AND msib.secondary_uom_code IS NOT NULL
4208: AND ROWNUM = 1;

Line 4434: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE

4430: END Create_Item;
4431:
4432:
4433: PROCEDURE Delete_Cost_Details(
4434: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4435: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4436: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4437: ,P_Cost_Txn IN NUMBER
4438: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE

Line 4435: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE

4431:
4432:
4433: PROCEDURE Delete_Cost_Details(
4434: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4435: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4436: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4437: ,P_Cost_Txn IN NUMBER
4438: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4439: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)

Line 4436: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE

4432:
4433: PROCEDURE Delete_Cost_Details(
4434: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4435: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4436: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4437: ,P_Cost_Txn IN NUMBER
4438: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4439: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4440: IS

Line 4438: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE

4434: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4435: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4436: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4437: ,P_Cost_Txn IN NUMBER
4438: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4439: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4440: IS
4441:
4442: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;

Line 4439: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)

4435: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4436: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4437: ,P_Cost_Txn IN NUMBER
4438: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4439: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4440: IS
4441:
4442: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;
4443: /* l_profile_exists BOOLEAN;

Line 4621: UPDATE mtl_system_items_b

4617: Update_Row(P_Item_Rec => P_Item_Rec);
4618:
4619: IF P_mode = 'DEFINE' THEN
4620: IF P_Updateble_Item = 'ALL' THEN
4621: UPDATE mtl_system_items_b
4622: SET segment1 = P_Item_rec.segment1
4623: ,segment2 = P_Item_rec.segment2
4624: ,segment3 = P_Item_rec.segment3
4625: ,segment4 = P_Item_rec.segment4

Line 5148: from MTL_SYSTEM_ITEMS_B

5144: , SUBCONTRACTING_COMPONENT
5145: , OUTSOURCED_ASSEMBLY
5146: -- Fix for Bug#6644711
5147: , DEFAULT_MATERIAL_STATUS_ID
5148: from MTL_SYSTEM_ITEMS_B
5149: where INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
5150: and ORGANIZATION_ID = P_Item_rec.organization_id
5151: for update of INVENTORY_ITEM_ID nowait;
5152:

Line 5896: FROM MTL_SYSTEM_ITEMS_B B

5892: BEGIN
5893:
5894: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T
5895: WHERE NOT EXISTS ( SELECT NULL
5896: FROM MTL_SYSTEM_ITEMS_B B
5897: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
5898: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);
5899:
5900: UPDATE MTL_SYSTEM_ITEMS_TL T

Line 6113: from MTL_SYSTEM_ITEMS_B

6109:
6110: CURSOR c_item_name IS
6111: SELECT
6112: SEGMENT1
6113: from MTL_SYSTEM_ITEMS_B
6114: where INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
6115: and ORGANIZATION_ID = P_Item_rec.organization_id
6116: for update of INVENTORY_ITEM_ID nowait;
6117: