DBA Data[Home] [Help]

APPS.WSMPCOGI dependencies on BOM_BILL_OF_MATERIALS

Line 18: FROM bom_bill_of_materials bbom,

14: BEGIN
15:
16: SELECT bbom.alternate_bom_designator
17: INTO x_alternate_designator
18: FROM bom_bill_of_materials bbom,
19: bom_inventory_components bic,
20: wsm_co_products bcp
21: WHERE bcp.co_product_group_id = x_co_product_group_id
22: AND bcp.component_sequence_id = bic.component_sequence_id

Line 137: bom_bill_of_materials bom

133: */
134: select bic.component_sequence_id
135: into l_id
136: from bom_inventory_components bic,
137: bom_bill_of_materials bom
138: where bom.bill_sequence_id = p_bill_sequence_id
139: and bic.bill_sequence_id = bom.common_bill_sequence_id
140: and bic.component_item_id = p_component_item_id
141: and bic.operation_seq_num = p_operation_sequence_num