DBA Data[Home] [Help]

APPS.CTO_UPDATE_CONFIGS_PK dependencies on BOM_BILL_OF_MATERIALS

Line 3847: from bom_bill_of_materials bbom,

3843: bic.wip_supply_type,
3844: bic.component_sequence_id
3845: into p_t_bcol(v_item).wip_supply_type,
3846: p_t_bcol(v_item).component_sequence_id
3847: from bom_bill_of_materials bbom,
3848: bom_inventory_components bic
3849: where bbom.bill_sequence_id =
3850: (select common_bill_sequence_id
3851: from bom_bill_of_materials

Line 3851: from bom_bill_of_materials

3847: from bom_bill_of_materials bbom,
3848: bom_inventory_components bic
3849: where bbom.bill_sequence_id =
3850: (select common_bill_sequence_id
3851: from bom_bill_of_materials
3852: where assembly_item_id = p_t_bcol(v_parent_item).inventory_item_id
3853: and alternate_bom_designator is null
3854: and rownum = 1)
3855: and bbom.common_bill_sequence_id = bic.bill_sequence_id