DBA Data[Home] [Help]

APPS.OE_CONFIG_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 4433: FROM bom_bill_of_materials

4429:
4430: BEGIN
4431: SELECT bill_sequence_id
4432: INTO l_parent_component_sequence_id
4433: FROM bom_bill_of_materials
4434: WHERE ASSEMBLY_ITEM_ID = l_parent_line_rec.inventory_item_id
4435: AND ORGANIZATION_ID = l_validation_org
4436: AND ALTERNATE_BOM_DESIGNATOR IS NULL;
4437:

Line 8994: FROM bom_bill_of_materials bom, oe_order_lines_all oel

8990: -- get sets to Bom_Explosion_Rec
8991: CURSOR C_Bill_Seq_id ( p_top_model_line_id IN NUMBER, p_header_id IN NUMBER
8992: , p_validation_org IN NUMBER) IS
8993: SELECT bom.bill_sequence_id, oel.line_id, oel.inventory_item_id
8994: FROM bom_bill_of_materials bom, oe_order_lines_all oel
8995: WHERE bom.ASSEMBLY_ITEM_ID = oel.inventory_item_id
8996: AND oel.top_model_line_id = p_top_model_line_id
8997: AND oel.header_id = p_header_id
8998: AND oel.item_type_code in (OE_GLOBALS.G_ITEM_CLASS,OE_GLOBALS.G_ITEM_KIT,OE_GLOBALS.G_ITEM_MODEL)