DBA Data[Home] [Help]

APPS.WIP_SCHEDULING dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 176: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI

172: FROM WIP_OPERATIONS
173: WHERE (WIP_ENTITY_ID, ORGANIZATION_ID) IN
174: (SELECT WIP_ENTITY_ID,
175: ORGANIZATION_ID
176: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI
177: WHERE WJSI.GROUP_ID = P_JOB_INTERFACE_GROUP_ID
178: AND WJSI.PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
179: AND WJSI.PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE));
180:

Line 235: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI

231: FROM WIP_OPERATION_RESOURCES
232: WHERE (WIP_ENTITY_ID, ORGANIZATION_ID) IN
233: (SELECT WIP_ENTITY_ID,
234: ORGANIZATION_ID
235: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI
236: WHERE WJSI.GROUP_ID = P_JOB_INTERFACE_GROUP_ID
237: AND WJSI.PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
238: AND WJSI.PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE));
239: END IF;