APPS.BOM_REFERENCE_DESIGNATOR_API dependencies on BOM_INVENTORY_COMPONENTS

Line 326: FROM bom_inventory_components

322: stmt_num := 7;
323: BEGIN
324: SELECT component_sequence_id
325: INTO c1rec.CSI
326: FROM bom_inventory_components
327: WHERE bill_sequence_id = c1rec.BSI
328: AND component_item_id = c1rec.CII
329: AND operation_seq_num = c1rec.OSN
330: AND effectivity_date = to_date(c1rec.ED,'YYYY/MM/DD HH24:MI:SS');

Line 808: bom_inventory_components bic

804: X_program_application_id, X_program_id,
805: X_program_update_date, X_quantity_related,
806: X_component_quantity
807: FROM bom_reference_designators brd,
808: bom_inventory_components bic
809: WHERE brd.component_sequence_id = c2rec.CSI
810: AND brd.component_reference_designator = c2rec.CRD
811: AND brd.component_sequence_id = bic.component_sequence_id
812: AND bic.implementation_date is not null;

Line 1086: FROM bom_inventory_components bic,

1082: bic.component_quantity, bic.quantity_related
1083: INTO assy_id_dummy, org_id_dummy, assy_type_dummy,
1084: comp_id_dummy, comp_type, dummy,
1085: X_component_quantity, X_quantity_related
1086: FROM bom_inventory_components bic,
1087: bom_bill_of_materials bbom,
1088: mtl_system_items mtl
1089: WHERE bic.component_sequence_id = c1rec.CSI
1090: AND bic.implementation_date is not null