DBA Data[Home] [Help]

APPS.WSMPVCPD dependencies on WSM_CO_PROD_COMP_SUBSTITUTES

Line 133: ** FROM wsm_co_prod_comp_substitutes bcs

129: ** SELECT 1
130: ** INTO x_dummy
131: ** FROM sys.dual
132: ** WHERE NOT EXISTS (SELECT 1
133: ** FROM wsm_co_prod_comp_substitutes bcs
134: ** WHERE bcs.co_product_group_id = x_co_product_group_id
135: ** AND bcs.substitute_component_id = x_co_product_id);
136: **
137: ** EXCEPTION

Line 148: FROM wsm_co_prod_comp_substitutes bcs

144: x1_dummy := 0;
145:
146: SELECT 1
147: INTO x1_dummy
148: FROM wsm_co_prod_comp_substitutes bcs
149: WHERE bcs.co_product_group_id = x_co_product_group_id
150: AND bcs.substitute_component_id = x_co_product_id;
151:
152: IF x1_dummy <> 0 THEN