DBA Data[Home] [Help]

APPS.WIP_COMMON dependencies on WIP_DEF_CAT_ACC_CLASSES

Line 75: wip_def_cat_acc_classes wdcac

71: begin
72: select wdcac.std_discrete_class, wdcac.repetitive_assy_class
73: into V_DISC_CLASS, V_REP_CLASS
74: from mtl_default_category_sets mdcs, mtl_item_categories mic,
75: wip_def_cat_acc_classes wdcac
76: where
77: mdcs.functional_area_id = V_PRODUCT_LINE and
78: mdcs.category_set_id = mic.category_set_id and
79: mic.organization_id = X_ORG_ID and

Line 162: wip_def_cat_acc_classes wdcac

158: begin
159: select wdcac.std_discrete_class
160: into V_DISC_CLASS
161: from mtl_default_category_sets mdcs, mtl_item_categories mic,
162: wip_def_cat_acc_classes wdcac
163: where
164: mdcs.functional_area_id = V_PRODUCT_LINE and
165: mdcs.category_set_id = mic.category_set_id and
166: mic.organization_id = X_ORG_ID and

Line 231: -- in mrp_project_parameters or wip_def_cat_acc_classes

227: end if;
228: else
229: return(NULL);
230: -- Project Id is defined but no class defined
231: -- in mrp_project_parameters or wip_def_cat_acc_classes
232: end if;
233:
234: exception
235: when NO_DATA_FOUND then