APPS.CST_EAMJOB_ACTESTIMATE dependencies on BOM_BILL_OF_MATERIALS

Line 495: FROM bom_bill_of_materials bbom,

491: NVL(ccicv.item_cost,0))
492: )
493: ), l_ext_precision
494: ) mat_value
495: FROM bom_bill_of_materials bbom,
496: bom_inventory_components bic,
497: cst_cg_item_costs_view ccicv,
498: bom_operational_routings bor,
499: bom_operation_sequences bos,

Line 515: FROM bom_bill_of_materials bbom1

511: OR ((p_alt_bom_designator IS NOT NULL)
512: AND (bbom.alternate_bom_designator IS NULL)
513: AND NOT EXISTS
514: (SELECT 'X'
515: FROM bom_bill_of_materials bbom1
516: WHERE bbom1.assembly_item_id = bbom.assembly_item_id
517: AND bbom1.organization_id = bbom.organization_id
518: AND bbom1.alternate_bom_designator
519: = p_alt_bom_designator)