DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on WIP_DISCRETE_JOBS

Line 1085: from wip_discrete_jobs

1081: end if;
1082:
1083: select job_type
1084: into l_job_type
1085: from wip_discrete_jobs
1086: where wip_entity_id = wipEntityID
1087: and organization_id = orgID;
1088:
1089: /* ER 4163405: Re-add the condition here for return transactions only */

Line 1712: FROM wip_discrete_jobs wdj,

1708: itemID, -- item_id
1709: sysdate -- rev_date
1710: ))
1711: INTO revision
1712: FROM wip_discrete_jobs wdj,
1713: mtl_item_revisions mir
1714: WHERE wdj.organization_id = mir.organization_id
1715: AND wdj.wip_entity_id = wipEntityID
1716: AND mir.organization_id = orgID