DBA Data[Home] [Help]

APPS.WIP_DISCRETE_INIT dependencies on STANDARD

Line 158: FROM WIP_STANDARD_CLASSES_VAL_V wac

154: FROM WIP_PARAMETERS wp
155: WHERE wp.ORGANIZATION_ID = p_organization_id;
156: CURSOR c2 IS
157: SELECT DECODE(count(*),0,0,1)
158: FROM WIP_STANDARD_CLASSES_VAL_V wac
159: WHERE wac.ORGANIZATION_ID = p_organization_id;
160: CURSOR c3 IS
161: SELECT DECODE(count(*),0,0,2)
162: FROM WIP_NON_STANDARD_CLASSES_VAL_V wac

Line 162: FROM WIP_NON_STANDARD_CLASSES_VAL_V wac

158: FROM WIP_STANDARD_CLASSES_VAL_V wac
159: WHERE wac.ORGANIZATION_ID = p_organization_id;
160: CURSOR c3 IS
161: SELECT DECODE(count(*),0,0,2)
162: FROM WIP_NON_STANDARD_CLASSES_VAL_V wac
163: WHERE wac.ORGANIZATION_ID = p_organization_id;
164: CURSOR c4 (cc VARCHAR2) IS
165: SELECT NVL(DISABLE_DATE,SYSDATE+1),
166: MATERIAL_ACCOUNT,