DBA Data[Home] [Help]

APPS.WIP_MASSLOAD_PUB dependencies on WIP_JOB_DTLS_INTERFACE

Line 158: wip_job_dtls_interface wjdi

154:
155: select count(*)
156: into l_totalNum
157: from wip_job_schedule_interface wjsi,
158: wip_job_dtls_interface wjdi
159: where wjdi.parent_header_id = wjsi.header_id
160: and wjdi.group_id = wjsi.group_id
161: and wjdi.process_phase = wip_constants.ml_validation
162: and wjdi.process_status = wip_constants.pending

Line 506: wip_job_dtls_interface wjdi

502:
503: select count(*)
504: into l_totalNum
505: from wip_job_schedule_interface wjsi,
506: wip_job_dtls_interface wjdi
507: where wjdi.parent_header_id = wjsi.header_id
508: and wjdi.group_id = wjsi.group_id
509: and wjdi.process_phase = wip_constants.ml_validation
510: and wjdi.process_status = wip_constants.pending