DBA Data[Home] [Help]

APPS.WIP_MASSLOAD_PUB dependencies on WIP_JOB_DTLS_INTERFACE

Line 125: wip_job_dtls_interface wjdi

121:
122: select count(*)
123: into l_totalNum
124: from wip_job_schedule_interface wjsi,
125: wip_job_dtls_interface wjdi
126: where wjdi.parent_header_id = wjsi.header_id
127: and wjdi.group_id = wjsi.group_id
128: and wjdi.process_phase = wip_constants.ml_validation
129: and wjdi.process_status = wip_constants.pending

Line 363: wip_job_dtls_interface wjdi

359:
360: select count(*)
361: into l_totalNum
362: from wip_job_schedule_interface wjsi,
363: wip_job_dtls_interface wjdi
364: where wjdi.parent_header_id = wjsi.header_id
365: and wjdi.group_id = wjsi.group_id
366: and wjdi.process_phase = wip_constants.ml_validation
367: and wjdi.process_status = wip_constants.pending