APPS.PO_DOCUMENT_CHECKS_PVT dependencies on WIP_DISCRETE_JOBS

Line 23386: -- checking the status from WIP_DISCRETE_JOBS table.Whichever WO is not in

23382: * messages inserted
23383: -- Updated for bug#15939036
23384: -- Details:
23385: -- Instead of checking the WO invalid state from view WIP_OSP_JOBSVAL_V
23386: -- checking the status from WIP_DISCRETE_JOBS table.Whichever WO is not in
23387: -- status 3,4,6 are treated as invalid WO's.As the validation from view is failing for
23388: -- some flows when WO is created from EAM.Please refer bug for further details.
23389: */
23390: PROCEDURE CHECK_CLOSE_WIP_JOB(p_document_id IN NUMBER,

Line 23449: FROM wip_discrete_jobs wdj

23445: AND nvl(prl.closed_code,'OPEN') NOT IN ('FINALLY CLOSED' , 'CLOSED')
23446: AND prl.requisition_header_id = p_document_id
23447: AND prl.wip_entity_id IS NOT NULL --Bug 14383315
23448: AND NOT EXISTS (SELECT 'JOB IS VALID'
23449: FROM wip_discrete_jobs wdj
23450: WHERE prl.wip_entity_id = wdj.wip_entity_id
23451: AND wdj.status_type IN (3,4,6)
23452: UNION ALL --Bug 16767247
23453: SELECT 'JOB IS VALID'

Line 23507: FROM wip_discrete_jobs wdj

23503: AND nvl(pll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED' , 'CLOSED')
23504: AND pr.po_release_id = p_document_id
23505: AND pd.wip_entity_id IS NOT NULL --Bug 14383315
23506: AND NOT EXISTS (SELECT 'JOB IS VALID'
23507: FROM wip_discrete_jobs wdj
23508: WHERE pd.wip_entity_id = wdj.wip_entity_id
23509: AND wdj.status_type IN (3,4,6)
23510: UNION ALL --Bug 16767247
23511: SELECT 'JOB IS VALID'

Line 23567: FROM wip_discrete_jobs wdj

23563: AND nvl(pll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED' , 'CLOSED')
23564: AND ph.po_header_id = p_document_id
23565: AND pd.wip_entity_id IS NOT NULL --Bug 14383315
23566: AND NOT EXISTS (SELECT 'JOB IS VALID'
23567: FROM wip_discrete_jobs wdj
23568: WHERE pd.wip_entity_id = wdj.wip_entity_id
23569: AND wdj.status_type IN (3,4,6)
23570: UNION ALL --Bug 16767247
23571: SELECT 'JOB IS VALID'