DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on WIP_REPETITIVE_SCHEDULES

Line 23454: FROM wip_repetitive_schedules 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'
23454: FROM wip_repetitive_schedules wdj
23455: WHERE prl.wip_entity_id = wdj.wip_entity_id
23456: AND wdj.status_type IN (3,4,6));
23457:
23458: ELSIF p_document_type = g_document_type_RELEASE THEN

Line 23512: FROM wip_repetitive_schedules 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'
23512: FROM wip_repetitive_schedules wdj
23513: WHERE pd.wip_entity_id = wdj.wip_entity_id
23514: AND wdj.status_type IN (3,4,6));
23515:
23516: ELSE--Other than document type RELEASE,REQUISITION

Line 23572: FROM wip_repetitive_schedules 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'
23572: FROM wip_repetitive_schedules wdj
23573: WHERE pd.wip_entity_id = wdj.wip_entity_id
23574: AND wdj.status_type IN (3,4,6));
23575:
23576: END IF;