DBA Data[Home] [Help]

APPS.WSMPCOGI dependencies on WSM_CO_PRODUCTS

Line 20: wsm_co_products bcp

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
23: AND bic.bill_sequence_id = bbom.bill_sequence_id
24: AND rownum = 1;

Line 55: FROM wsm_co_products

51: x_progress := '010';
52:
53: SELECT count (*)
54: INTO x_count
55: FROM wsm_co_products
56: WHERE co_product_group_id = x_co_product_group_id
57: AND co_product_id IS NOT NULL;
58:
59: x_error_code := 0;