APPS.OE_OPT_PROCESS dependencies on MTL_SYSTEM_ITEMS

Line 44: ,MTL_SYSTEM_ITEMS MTLITM

40: ,DECODE( BOMEXP.COMPONENT_CODE,
41: x_options_comp_code, NULL, OELIN.LINE_ID )
42: ,BOMEXP.COMPONENT_CODE
43: FROM BOM_EXPLOSIONS BOMEXP
44: ,MTL_SYSTEM_ITEMS MTLITM
45: ,SO_LINES OELIN
46: WHERE BOMEXP.TOP_BILL_SEQUENCE_ID = x_lines_comp_seq_id
47: AND BOMEXP.EXPLOSION_TYPE = 'OPTIONAL'
48: AND BOMEXP.PLAN_LEVEL <= x_options_plan_level

Line 96: FROM MTL_SYSTEM_ITEMS

92: 'UNKNOWN' ),
93: NVL(SERVICEABLE_PRODUCT_FLAG,'N')
94: INTO Options_ITEM_TYPE_CODE,
95: Serviceable_Flag
96: FROM MTL_SYSTEM_ITEMS
97: WHERE ORGANIZATION_ID = P_Organization_Id
98: AND INVENTORY_ITEM_ID = Options_INVENTORY_ITEM_ID;
99:
100: select meaning into Options_Item_Type from so_lookups

Line 191: FROM MTL_SYSTEM_ITEMS

187: Apply_Order_Adjs_Flag:='Y';
188:
189: SELECT NVL(SERVICEABLE_PRODUCT_FLAG,'N')
190: INTO Options_Serviceable_Flag
191: FROM MTL_SYSTEM_ITEMS
192: WHERE ORGANIZATION_ID = World_Organization_Id
193: AND INVENTORY_ITEM_ID = Options_Inventory_Item_Id;
194:
195: exception