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

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 570: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN

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
573: l_transactable_status := l_status_ctrl;
574: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

Line 572: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

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
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

Line 574: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

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
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

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 578: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN

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
581: l_int_ord_status := l_status_ctrl;
582: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

Line 580: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

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
581: l_int_ord_status := l_status_ctrl;
582: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
583: l_invoiceable_status := l_status_ctrl;
584: END IF;

Line 582: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

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
581: l_int_ord_status := l_status_ctrl;
582: ELSIF l_status_attr = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
583: l_invoiceable_status := l_status_ctrl;
584: END IF;
585:
586: END LOOP;

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 598: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG' THEN

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
601: l_transactable_value := l_attr_value;
602: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

Line 600: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG' THEN

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
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

Line 602: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG' THEN

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
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

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 606: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG' THEN

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
609: l_int_ord_value := l_attr_value;
610: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

Line 608: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG' THEN

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
609: l_int_ord_value := l_attr_value;
610: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
611: l_invoiceable_value := l_attr_value;
612: END IF;

Line 610: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN

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
609: l_int_ord_value := l_attr_value;
610: ELSIF l_attr_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG' THEN
611: l_invoiceable_value := l_attr_value;
612: END IF;
613:
614: END LOOP;

Line 634: FROM mtl_system_items_tl

630: l_update_child_rec := FALSE; --Bug: 5220205
631: -- Bug 4388141. Populate long description in l_item_rec.long_description
632: SELECT description , long_description
633: INTO l_item_rec.description , l_item_rec.long_description
634: FROM mtl_system_items_tl
635: WHERE inventory_item_id = l_item_rec.inventory_item_id
636: AND organization_id = l_item_rec.organization_id
637: AND language = userenv('LANG');
638:

Line 3089: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

3085:
3086:
3087: PROCEDURE Check_Item_Number (
3088: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3089: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3090: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3091: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3092: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)
3093: IS

Line 3090: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE

3086:
3087: PROCEDURE Check_Item_Number (
3088: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3089: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3090: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3091: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3092: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)
3093: IS
3094:

Line 3091: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE

3087: PROCEDURE Check_Item_Number (
3088: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3089: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3090: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3091: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3092: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)
3093: IS
3094:
3095: l_sql_stmt VARCHAR2(3200);

Line 3092: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)

3088: P_Segment_Rec IN INV_ITEM_API.Item_rec_type
3089: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
3090: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
3091: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
3092: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE)
3093: IS
3094:
3095: l_sql_stmt VARCHAR2(3200);
3096: l_segments_string VARCHAR2(1000);

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 3177: l_mast_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE;

3173: l_party_id FND_USER.CUSTOMER_ID%TYPE;
3174: l_grant_guid fnd_grants.grant_guid%TYPE;
3175: l_ego_exists VARCHAR2(1) := 'N';
3176: l_master_org VARCHAR2(1); --R12: Business Events
3177: l_mast_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE;
3178:
3179: BEGIN
3180: -- Primary_Unit_of_Measure lookup
3181:

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 3984: INSERT INTO MTL_SYSTEM_ITEMS_TL(

3980: IF (P_Item_Rec.organization_id = Get_Master_Org_ID (P_Item_Rec.organization_id) ) THEN
3981: -- If the Org is master, insert the source language translated columns
3982: -- for child organizations.
3983:
3984: INSERT INTO MTL_SYSTEM_ITEMS_TL(
3985: INVENTORY_ITEM_ID,
3986: ORGANIZATION_ID,
3987: LANGUAGE,
3988: SOURCE_LANG,

Line 4012: FROM MTL_SYSTEM_ITEMS_TL T

4008: FROM FND_LANGUAGES L
4009: WHERE L.INSTALLED_FLAG in ('I', 'B')
4010: AND NOT EXISTS
4011: ( SELECT NULL
4012: FROM MTL_SYSTEM_ITEMS_TL T
4013: WHERE T.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4014: AND T.ORGANIZATION_ID = P_Item_Rec.ORGANIZATION_ID
4015: AND T.LANGUAGE = L.LANGUAGE_CODE);
4016: ELSE

Line 4019: INSERT INTO MTL_SYSTEM_ITEMS_TL (

4015: AND T.LANGUAGE = L.LANGUAGE_CODE);
4016: ELSE
4017: -- If the Org is not master, then while creating new child items,
4018: -- copy translated columns from the master item record.
4019: INSERT INTO MTL_SYSTEM_ITEMS_TL (
4020: INVENTORY_ITEM_ID,
4021: ORGANIZATION_ID,
4022: LANGUAGE,
4023: SOURCE_LANG,

Line 4044: MTL_SYSTEM_ITEMS_TL MSI,

4040: P_Item_Rec.CREATION_DATE,
4041: P_Item_Rec.CREATED_BY,
4042: P_Item_Rec.LAST_UPDATE_LOGIN
4043: FROM
4044: MTL_SYSTEM_ITEMS_TL MSI,
4045: MTL_PARAMETERS MP
4046: WHERE
4047: MSI.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4048: AND MSI.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

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 4231: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

4227: PROCEDURE Create_Item(
4228: P_Item_Rec IN INV_ITEM_API.Item_rec_type
4229: ,P_Item_Category_Struct_Id IN NUMBER
4230: ,P_Inv_Install IN NUMBER
4231: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4232: ,P_Category_Set_Id IN NUMBER
4233: ,P_Item_Category_Id IN NUMBER
4234: ,P_Event IN VARCHAR2 DEFAULT 'INSERT'
4235: ,x_row_Id OUT NOCOPY ROWID

Line 4248: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

4244: FROM MTL_UNITS_OF_MEASURE_VL
4245: WHERE UNIT_OF_MEASURE = cp_uom
4246: OR uom_code = cp_uom_code;
4247:
4248: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4249: ,cp_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE)
4250: IS
4251: SELECT COUNT(1)
4252: FROM MTL_SYSTEM_ITEMS

Line 4249: ,cp_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE)

4245: WHERE UNIT_OF_MEASURE = cp_uom
4246: OR uom_code = cp_uom_code;
4247:
4248: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4249: ,cp_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE)
4250: IS
4251: SELECT COUNT(1)
4252: FROM MTL_SYSTEM_ITEMS
4253: WHERE INVENTORY_ITEM_ID = cp_Item_Id

Line 4252: FROM MTL_SYSTEM_ITEMS

4248: Cursor c_get_item_count(cp_Org_Id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4249: ,cp_Item_Id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE)
4250: IS
4251: SELECT COUNT(1)
4252: FROM MTL_SYSTEM_ITEMS
4253: WHERE INVENTORY_ITEM_ID = cp_Item_Id
4254: AND ORGANIZATION_ID = cp_org_id;
4255:
4256: l_item_count NUMBER :=0;

Line 4257: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;

4253: WHERE INVENTORY_ITEM_ID = cp_Item_Id
4254: AND ORGANIZATION_ID = cp_org_id;
4255:
4256: l_item_count NUMBER :=0;
4257: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4258: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4259: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4260: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4261: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;

Line 4259: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;

4255:
4256: l_item_count NUMBER :=0;
4257: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4258: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4259: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4260: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4261: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4262: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4263: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;

Line 4260: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;

4256: l_item_count NUMBER :=0;
4257: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4258: l_primary_uom_code MTL_UNITS_OF_MEASURE_VL.UOM_CODE%TYPE;
4259: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4260: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4261: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4262: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4263: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4264: l_catalog_grp_id NUMBER;

Line 4263: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;

4259: l_new_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
4260: l_unit_of_measure MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE;
4261: l_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE := NULL;
4262: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4263: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
4264: l_catalog_grp_id NUMBER;
4265: l_folder_item_cat_id NUMBER := NULL;
4266: /* Bug 3713912 */
4267: l_rec_sec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

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 4548: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

4544: PROCEDURE Update_Item(
4545: P_Item_Rec IN INV_ITEM_API.Item_rec_type
4546: ,P_Item_Category_Struct_Id IN NUMBER
4547: ,P_Inv_Install IN NUMBER
4548: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
4549: ,P_Category_Set_Id IN NUMBER
4550: ,P_Item_Category_Id IN NUMBER
4551: ,P_Mode IN VARCHAR2
4552: ,P_Updateble_Item IN VARCHAR2

Line 4555: ,P_Inv_Item_status_old IN MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE

4551: ,P_Mode IN VARCHAR2
4552: ,P_Updateble_Item IN VARCHAR2
4553: ,P_Cost_Txn IN VARCHAR2
4554: ,P_Item_Cost_Details IN VARCHAR2
4555: ,P_Inv_Item_status_old IN MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE
4556: ,P_Default_Move_Order_Sub_Inv IN VARCHAR2 -- Item Transaction Defaults for 11.5.9
4557: ,P_Default_Receiving_Sub_Inv IN VARCHAR2
4558: ,P_Default_Shipping_Sub_Inv IN VARCHAR2
4559: ) IS

Line 4568: l_cst_item_type MTL_SYSTEM_ITEMS_FVL.PLANNING_MAKE_BUY_CODE%TYPE;

4564: WHERE UNIT_OF_MEASURE = cp_uom;
4565:
4566: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4567: l_folder_item_cat_id NUMBER := NULL;
4568: l_cst_item_type MTL_SYSTEM_ITEMS_FVL.PLANNING_MAKE_BUY_CODE%TYPE;
4569: l_Inventory_Item_status MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE;
4570: l_event VARCHAR2(10);
4571: l_return_status VARCHAR2(1);
4572: l_msg_count NUMBER;

Line 4569: l_Inventory_Item_status MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE;

4565:
4566: l_rec_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
4567: l_folder_item_cat_id NUMBER := NULL;
4568: l_cst_item_type MTL_SYSTEM_ITEMS_FVL.PLANNING_MAKE_BUY_CODE%TYPE;
4569: l_Inventory_Item_status MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE;
4570: l_event VARCHAR2(10);
4571: l_return_status VARCHAR2(1);
4572: l_msg_count NUMBER;
4573: l_msg_data VARCHAR2(2000);

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 5158: FROM MTL_SYSTEM_ITEMS_TL

5154: SELECT
5155: DESCRIPTION,
5156: LONG_DESCRIPTION,
5157: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
5158: FROM MTL_SYSTEM_ITEMS_TL
5159: WHERE INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
5160: AND ORGANIZATION_ID = P_Item_rec.organization_id
5161: for update of INVENTORY_ITEM_ID nowait;
5162:

Line 5886: RAISE_APPLICATION_ERROR (-20000, 'Cannot delete Item using MTL_SYSTEM_ITEMS_PKG.DELETE_ROW');

5882:
5883: PROCEDURE DELETE_ROW IS
5884: BEGIN
5885: -- DELETE_ROW cannot be used to delete Item records.
5886: RAISE_APPLICATION_ERROR (-20000, 'Cannot delete Item using MTL_SYSTEM_ITEMS_PKG.DELETE_ROW');
5887: END DELETE_ROW;
5888:
5889: -- ------------------- ADD_LANGUAGE --------------------
5890:

Line 5894: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T

5890:
5891: PROCEDURE ADD_LANGUAGE IS
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);

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 5900: UPDATE MTL_SYSTEM_ITEMS_TL T

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
5901: SET( DESCRIPTION
5902: , LONG_DESCRIPTION) = (SELECT ltrim(rtrim(B.DESCRIPTION))
5903: , ltrim(rtrim(B.LONG_DESCRIPTION))
5904: FROM MTL_SYSTEM_ITEMS_TL B

Line 5904: FROM MTL_SYSTEM_ITEMS_TL B

5900: UPDATE MTL_SYSTEM_ITEMS_TL T
5901: SET( DESCRIPTION
5902: , LONG_DESCRIPTION) = (SELECT ltrim(rtrim(B.DESCRIPTION))
5903: , ltrim(rtrim(B.LONG_DESCRIPTION))
5904: FROM MTL_SYSTEM_ITEMS_TL B
5905: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
5906: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
5907: AND B.LANGUAGE = T.SOURCE_LANG)
5908: WHERE(T.INVENTORY_ITEM_ID

Line 5913: FROM MTL_SYSTEM_ITEMS_TL SUBB,

5909: , T.ORGANIZATION_ID
5910: , T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
5911: SUBT.ORGANIZATION_ID,
5912: SUBT.LANGUAGE
5913: FROM MTL_SYSTEM_ITEMS_TL SUBB,
5914: MTL_SYSTEM_ITEMS_TL SUBT
5915: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
5916: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
5917: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 5914: MTL_SYSTEM_ITEMS_TL SUBT

5910: , T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
5911: SUBT.ORGANIZATION_ID,
5912: SUBT.LANGUAGE
5913: FROM MTL_SYSTEM_ITEMS_TL SUBB,
5914: MTL_SYSTEM_ITEMS_TL SUBT
5915: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
5916: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
5917: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
5918: AND (( SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 5926: INSERT INTO MTL_SYSTEM_ITEMS_TL (

5922: or ( SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null )
5923: or ( SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null ))));
5924:
5925: */
5926: INSERT INTO MTL_SYSTEM_ITEMS_TL (
5927: INVENTORY_ITEM_ID,
5928: ORGANIZATION_ID,
5929: DESCRIPTION,
5930: LONG_DESCRIPTION,

Line 5950: FROM MTL_SYSTEM_ITEMS_TL B,

5946: B.CREATED_BY,
5947: B.LAST_UPDATE_LOGIN,
5948: L.LANGUAGE_CODE,
5949: B.SOURCE_LANG
5950: FROM MTL_SYSTEM_ITEMS_TL B,
5951: FND_LANGUAGES L
5952: WHERE L.INSTALLED_FLAG in ('I', 'B')
5953: AND B.LANGUAGE = userenv('LANG')
5954: AND NOT EXISTS( SELECT NULL

Line 5955: FROM MTL_SYSTEM_ITEMS_TL T

5951: FND_LANGUAGES L
5952: WHERE L.INSTALLED_FLAG in ('I', 'B')
5953: AND B.LANGUAGE = userenv('LANG')
5954: AND NOT EXISTS( SELECT NULL
5955: FROM MTL_SYSTEM_ITEMS_TL T
5956: WHERE T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
5957: AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
5958: AND T.LANGUAGE = L.LANGUAGE_CODE);
5959:

Line 5982: FROM MTL_SYSTEM_ITEMS_TL

5978: ,LANGUAGE
5979: ,SOURCE_LANG
5980: ,DESCRIPTION
5981: ,LONG_DESCRIPTION
5982: FROM MTL_SYSTEM_ITEMS_TL
5983: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
5984: AND ORGANIZATION_ID IN ( SELECT ORGANIZATION_ID
5985: FROM MTL_PARAMETERS
5986: WHERE MASTER_ORGANIZATION_ID = X_ORGANIZATION_ID

Line 6000: where attribute_name = 'MTL_SYSTEM_ITEMS.DESCRIPTION';

5996: begin
5997: select control_level
5998: into l_desc_control
5999: from mtl_item_attributes
6000: where attribute_name = 'MTL_SYSTEM_ITEMS.DESCRIPTION';
6001: exception
6002: when no_data_found then
6003: l_desc_control := 0;
6004: end;

Line 6010: where attribute_name = 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION';

6006: begin
6007: select control_level
6008: into l_longdesc_control
6009: from mtl_item_attributes
6010: where attribute_name = 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION';
6011: exception
6012: when no_data_found then
6013: l_longdesc_control := 0;
6014: end;

Line 6027: update mtl_system_items_tl

6023: app_exception.raise_exception;
6024: return ;
6025: end if;
6026: /*
6027: update mtl_system_items_tl
6028: set description = ltrim(rtrim(x_description)),
6029: long_description = ltrim(rtrim(x_long_description)),
6030: source_lang = x_language,
6031: last_updated_by = fnd_profile.value('USER_ID'),

Line 6040: update mtl_system_items_tl

6036: */
6037: for c1 in Item_csr
6038: loop
6039: if (l_desc_control = 1) then
6040: update mtl_system_items_tl
6041: set description = ltrim(rtrim(x_description)),
6042: source_lang = x_language,
6043: last_update_date = sysdate,
6044: last_updated_by = fnd_profile.value('USER_ID'),

Line 6051: update mtl_system_items_tl

6047:
6048: end if;
6049:
6050: if (l_longdesc_control = 1) then
6051: update mtl_system_items_tl
6052: set long_description = ltrim(rtrim(x_long_description)),
6053: source_lang = x_language,
6054: last_update_date = sysdate,
6055: last_updated_by = fnd_profile.value('USER_ID'),

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: