[Home] [Help]
192: l_created_by NUMBER;
193: BEGIN
194: l_created_by := 1;
195:
196: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
197: SET
198: ( I.LAST_UPDATED_BY,
199: I.CREATED_BY,
200: I.SUMMARY_FLAG,
1022: , NVL(I.TRADE_ITEM_DESCRIPTOR ,M.TRADE_ITEM_DESCRIPTOR )
1023: , NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
1024: , NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
1025: FROM
1026: mtl_system_items_interface M
1027: WHERE
1028: M.inventory_item_id = item_id AND
1029: M.organization_id = master_org_id AND
1030: M.set_process_id = xset_id AND
1085: l_created_by := 1 ;
1086:
1087: SELECT primary_unit_of_measure, primary_uom_code
1088: INTO l_Primary_Unit_of_Measure, l_Primary_UOM_Code
1089: FROM MTL_SYSTEM_ITEMS_INTERFACE
1090: WHERE rowid = p_rowid;
1091:
1092: IF (l_Primary_UOM_Code IS NULL AND l_Primary_Unit_of_Measure IS NOT NULL) THEN
1093: /*Bug: 4932464 Perf Issue replaced mtl_all_primary_uoms_vv with mtl_units_of_measure_tl
1114: END;
1115:
1116: END IF;
1117:
1118: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
1119: SET
1120: ( I.LAST_UPDATED_BY,
1121: I.CREATED_BY,
1122: I.SUMMARY_FLAG,
2010: , NVL(I.TRADE_ITEM_DESCRIPTOR ,M.TRADE_ITEM_DESCRIPTOR )
2011: , NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
2012: , NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
2013: FROM
2014: mtl_system_items_tl MT
2015: , mtl_system_items_b M
2016: WHERE
2017: M.inventory_item_id = item_id
2018: AND M.organization_id = master_org_id
2011: , NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
2012: , NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
2013: FROM
2014: mtl_system_items_tl MT
2015: , mtl_system_items_b M
2016: WHERE
2017: M.inventory_item_id = item_id
2018: AND M.organization_id = master_org_id
2019: AND MT.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
2057: IS
2058:
2059: CURSOR c_ego_intf_rows IS
2060: SELECT tl.column_value
2061: FROM ego_interface_tl tl, mtl_system_items_interface msii
2062: WHERE tl.unique_id = msii.transaction_id
2063: AND tl.set_process_id = msii.set_process_id
2064: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
2065: AND UPPER(tl.column_name) = 'DESCRIPTION'
2060: SELECT tl.column_value
2061: FROM ego_interface_tl tl, mtl_system_items_interface msii
2062: WHERE tl.unique_id = msii.transaction_id
2063: AND tl.set_process_id = msii.set_process_id
2064: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
2065: AND UPPER(tl.column_name) = 'DESCRIPTION'
2066: AND tl.language = USERENV('LANG')
2067: AND msii.rowid = p_rowid;
2068:
2132: l_style_item_id,
2133: l_Primary_Unit_of_Measure,
2134: l_Primary_UOM_Code,
2135: l_item_catalog_group_id
2136: FROM mtl_system_items_interface I
2137: WHERE I.rowid = p_rowid;
2138:
2139: SELECT starting_revision
2140: INTO l_revision
2164: IF ( l_Primary_Unit_of_Measure IS NULL ) THEN
2165: IF (l_style_item_flag = 'N' ) THEN
2166: SELECT primary_unit_of_measure
2167: INTO l_Primary_Unit_Of_Measure
2168: FROM mtl_system_items_b
2169: WHERE inventory_item_id = l_style_item_id
2170: AND organization_id = l_org_id;
2171: ELSE
2172: l_Primary_Unit_of_Measure := uom_default;
2207: --- added attribute_category to below code
2208: ---
2209:
2210: IF (l_style_item_flag = 'N' ) THEN
2211: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
2212: SET (
2213: I.DESCRIPTION,
2214: I.LAST_UPDATED_BY,
2215: I.CREATED_BY,
2505: NVL(I.TRADE_ITEM_DESCRIPTOR, M.TRADE_ITEM_DESCRIPTOR),
2506: DECODE(g_is_dff_reference_org_id, 'N' , NVL(I.ATTRIBUTE_CATEGORY,M.ATTRIBUTE_CATEGORY),
2507: 'Y' , l_org_id
2508: )
2509: FROM mtl_system_items M
2510: WHERE M.inventory_item_id = l_style_item_id
2511: AND M.organization_id = l_org_id
2512: )
2513: WHERE I.ROWID = p_rowid;
2512: )
2513: WHERE I.ROWID = p_rowid;
2514: l_ret_status := 0;
2515: ELSE
2516: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I
2517: SET
2518: I.LAST_UPDATED_BY = org_id,
2519: I.CREATED_BY = l_created_by,
2520: I.SUMMARY_FLAG = NVL(I.SUMMARY_FLAG, 'N'), --Bug: 4918974
2758: BEGIN
2759: SELECT DEFAULT_CONTEXT_FIELD_NAME
2760: INTO l_context_name
2761: FROM FND_DESCRIPTIVE_FLEXS
2762: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_SYSTEM_ITEMS'
2763: AND APPLICATION_ID = 401;
2764:
2765: IF (INSTR(UPPER(l_context_name),'ORGANIZATION_ID',1) <> 0) THEN
2766: g_is_dff_reference_org_id := 'Y';