DBA Data[Home] [Help]

APPS.WIP_COMMON dependencies on WIP_DEF_CAT_ACC_CLASSES

Line 68: wip_def_cat_acc_classes wdcac

64: begin
65: select wdcac.std_discrete_class, wdcac.repetitive_assy_class
66: into V_DISC_CLASS, V_REP_CLASS
67: from mtl_default_category_sets mdcs, mtl_item_categories mic,
68: wip_def_cat_acc_classes wdcac
69: where
70: mdcs.functional_area_id = V_PRODUCT_LINE and
71: mdcs.category_set_id = mic.category_set_id and
72: mic.organization_id = X_ORG_ID and

Line 147: wip_def_cat_acc_classes wdcac

143: begin
144: select wdcac.std_discrete_class
145: into V_DISC_CLASS
146: from mtl_default_category_sets mdcs, mtl_item_categories mic,
147: wip_def_cat_acc_classes wdcac
148: where
149: mdcs.functional_area_id = V_PRODUCT_LINE and
150: mdcs.category_set_id = mic.category_set_id and
151: mic.organization_id = X_ORG_ID and

Line 210: -- in mrp_project_parameters or wip_def_cat_acc_classes

206: end if;
207: else
208: return(NULL);
209: -- Project Id is defined but no class defined
210: -- in mrp_project_parameters or wip_def_cat_acc_classes
211: end if;
212:
213: exception
214: when NO_DATA_FOUND then