DBA Data[Home] [Help]

APPS.BOM_DEFAULT_OP_SEQ dependencies on MTL_SYSTEM_ITEMS

Line 209: FROM MTL_SYSTEM_ITEMS

205: -- If Assembly Item Type = Model or Option, Return 1:Yes
206: -- Else If Assembly Item Type = Standard, Return 2:No
207: SELECT bom_item_type
208: INTO g_assy_item_type
209: FROM MTL_SYSTEM_ITEMS
210: WHERE organization_id = p_organization_id
211: AND inventory_item_id = p_revised_item_id ;
212:
213: IF g_assy_item_type in ( l_MODEL,l_OPTION_CLASS )