APPS.INVPUTLI dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 196: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I

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,

Line 1026: mtl_system_items_interface M

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

Line 1089: FROM MTL_SYSTEM_ITEMS_INTERFACE

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

Line 1118: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I

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,

Line 2061: FROM ego_interface_tl tl, mtl_system_items_interface msii

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'

Line 2064: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'

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:

Line 2136: FROM mtl_system_items_interface I

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

Line 2211: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I

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,

Line 2516: UPDATE MTL_SYSTEM_ITEMS_INTERFACE I

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