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 601: IF l_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN

597: LOOP
598: FETCH status_attr_control INTO l_status_attr, l_status_ctrl;
599: EXIT when status_attr_control%NOTFOUND;
600:
601: IF l_status_attr = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
602: l_bom_enabled_status := l_status_ctrl;
603: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
604: l_purchasable_status := l_status_ctrl;
605: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

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

605: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
606: l_transactable_status := l_status_ctrl;
607: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
608: l_stockable_status := l_status_ctrl;
609: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
610: l_wip_status := l_status_ctrl;
611: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
612: l_cust_ord_status := l_status_ctrl;
613: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

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

625: LOOP
626: FETCH status_attr_values INTO l_attr_name, l_attr_value;
627: EXIT when status_attr_values%NOTFOUND;
628:
629: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
630: l_bom_enabled_value := l_attr_value;
631: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
632: l_purchasable_value := l_attr_value;
633: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

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

633: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN
634: l_transactable_value := l_attr_value;
635: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
636: l_stockable_value := l_attr_value;
637: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
638: l_wip_value := l_attr_value;
639: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
640: l_cust_ord_value := l_attr_value;
641: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

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

655: LOOP
656: FETCH status_attr_values INTO l_attr_name, l_attr_value;
657: EXIT when status_attr_values%NOTFOUND;
658:
659: IF l_attr_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG' THEN
660: l_bom_enabled_value := l_attr_value;
661: l_bom_enabled_status_ctrl := l_status_ctrl_lvl;
662: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN
663: l_purchasable_value := l_attr_value;

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

667: l_transactable_status_ctrl := l_status_ctrl_lvl;
668: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN
669: l_stockable_value := l_attr_value;
670: l_stockable_status_ctrl := l_status_ctrl_lvl;
671: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG' THEN
672: l_wip_value := l_attr_value;
673: l_wip_status_ctrl := l_status_ctrl_lvl;
674: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN
675: l_cust_ord_value := l_attr_value;

Line 3367: FROM MTL_SYSTEM_ITEMS_B_KFV MSI,

3363: l_sql_stmt := 'SELECT INVENTORY_ITEM_ID,
3364: ITEM_CATALOG_GROUP_ID,
3365: PRIMARY_UNIT_OF_MEASURE,
3366: DESCRIPTION
3367: FROM MTL_SYSTEM_ITEMS_B_KFV MSI,
3368: MTL_PARAMETERS P
3369: WHERE MSI.ORGANIZATION_ID = P.ORGANIZATION_ID ';
3370:
3371: get_segments_string(P_Segment_Rec => P_Segment_Rec

Line 3470: INSERT INTO MTL_SYSTEM_ITEMS_B(

3466: l_VENDOR_WARRANTY_FLAG := 'N';
3467: l_USAGE_ITEM_FLAG := NULL;
3468: END IF;
3469:
3470: INSERT INTO MTL_SYSTEM_ITEMS_B(
3471: DESCRIPTION,
3472: INVENTORY_ITEM_ID,
3473: ORGANIZATION_ID,
3474: SUMMARY_FLAG,

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

4463: PROCEDURE check_mismatch_of_secuom_class(
4464: p_inventory_item_id IN NUMBER
4465: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4466: IS
4467: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4468: SELECT muomv.UOM_CLASS
4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib
4470: WHERE muomv.uom_code = msib.secondary_uom_code
4471: AND msib.inventory_item_id = Vinventory_item_id

Line 4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib

4465: ,p_secondary_uom_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
4466: IS
4467: Cursor c_check_sec_uom_class(Vinventory_item_id mtl_system_items_b.inventory_item_id%TYPE) IS
4468: SELECT muomv.UOM_CLASS
4469: FROM MTL_UNITS_OF_MEASURE_VL muomv, mtl_system_items_b msib
4470: WHERE muomv.uom_code = msib.secondary_uom_code
4471: AND msib.inventory_item_id = Vinventory_item_id
4472: AND msib.secondary_uom_code IS NOT NULL
4473: AND ROWNUM = 1;

Line 4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE

4695: END Create_Item;
4696:
4697:
4698: PROCEDURE Delete_Cost_Details(
4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE

Line 4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE

4696:
4697:
4698: PROCEDURE Delete_Cost_Details(
4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)

Line 4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE

4697:
4698: PROCEDURE Delete_Cost_Details(
4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4705: IS

Line 4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE

4699: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4705: IS
4706:
4707: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;

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

4700: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
4701: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
4702: ,P_Cost_Txn IN NUMBER
4703: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
4704: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE)
4705: IS
4706:
4707: l_prim_cost_method MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE;
4708: /* l_profile_exists BOOLEAN;

Line 4901: FROM mtl_system_items_b

4897:
4898: /* Bug 8512945 with base bug 8417326 : Below BEGIN Block is added */
4899: BEGIN
4900: SELECT 'Y' INTO l_exists
4901: FROM mtl_system_items_b
4902: WHERE inventory_item_id = P_Item_Rec.inventory_item_id
4903: AND organization_id = l_org_id;
4904:
4905: IF (P_Item_rec.organization_id = l_org_id) THEN

Line 4920: FROM mtl_system_items_b

4916: l_cst_item_type := 2;
4917: END IF;
4918: ELSE
4919: SELECT planning_make_buy_code INTO l_cst_item_type
4920: FROM mtl_system_items_b
4921: WHERE inventory_item_id = P_Item_Rec.inventory_item_id
4922: AND organization_id = l_org_id;
4923: END IF;
4924: END IF;

Line 4961: mtl_system_items_b WHERE inventory_item_id=P_Item_rec.inventory_item_id

4957:
4958: SELECT last_updated_by,last_update_date,LAST_UPDATE_LOGIN
4959: INTO l_last_updated_by ,l_last_update_date,l_last_update_login
4960: FROM
4961: mtl_system_items_b WHERE inventory_item_id=P_Item_rec.inventory_item_id
4962: AND organization_id= P_Master_Org_Id;
4963: */
4964:
4965:

Line 4968: UPDATE mtl_system_items_b

4964:
4965:
4966: IF P_mode = 'DEFINE' THEN
4967: IF P_Updateble_Item = 'ALL' THEN
4968: UPDATE mtl_system_items_b
4969: SET segment1 = P_Item_rec.segment1
4970: ,segment2 = P_Item_rec.segment2
4971: ,segment3 = P_Item_rec.segment3
4972: ,segment4 = P_Item_rec.segment4

Line 5502: from MTL_SYSTEM_ITEMS_B

5498: -- Fix for Bug#6644711
5499: , DEFAULT_MATERIAL_STATUS_ID
5500: -- Serial_Tagging Enh -- bug 9913552
5501: , SERIAL_TAGGING_FLAG
5502: from MTL_SYSTEM_ITEMS_B
5503: where INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
5504: and ORGANIZATION_ID = P_Item_rec.organization_id
5505: for update of INVENTORY_ITEM_ID nowait;
5506:

Line 6258: FROM MTL_SYSTEM_ITEMS_B B

6254: BEGIN
6255:
6256: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T
6257: WHERE NOT EXISTS ( SELECT NULL
6258: FROM MTL_SYSTEM_ITEMS_B B
6259: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
6260: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);
6261:
6262: UPDATE MTL_SYSTEM_ITEMS_TL T

Line 6413: FROM MTL_SYSTEM_ITEMS_B_KFV MSIK,

6409: MSIK.CREATED_BY ,
6410: SYSDATE ,
6411: MSIK.LAST_UPDATED_BY,
6412: MSIK.LAST_UPDATE_LOGIN
6413: FROM MTL_SYSTEM_ITEMS_B_KFV MSIK,
6414: FND_LANGUAGES L
6415: WHERE L.INSTALLED_FLAG in ('I', 'B')
6416: AND MSIK.CONCATENATED_SEGMENTS IS NOT NULL
6417: AND MSIK.INVENTORY_ITEM_ID IS NOT NULL

Line 6616: from MTL_SYSTEM_ITEMS_B

6612:
6613: CURSOR c_item_name IS
6614: SELECT
6615: SEGMENT1
6616: from MTL_SYSTEM_ITEMS_B
6617: where INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
6618: and ORGANIZATION_ID = P_Item_rec.organization_id
6619: for update of INVENTORY_ITEM_ID nowait;
6620: