DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on WIP_DISCRETE_JOBS

Line 1076: from wip_discrete_jobs

1072: end if;
1073:
1074: select job_type
1075: into l_job_type
1076: from wip_discrete_jobs
1077: where wip_entity_id = wipEntityID
1078: and organization_id = orgID;
1079:
1080: /* ER 4163405: Re-add the condition here for return transactions only */

Line 1703: FROM wip_discrete_jobs wdj,

1699: itemID, -- item_id
1700: sysdate -- rev_date
1701: ))
1702: INTO revision
1703: FROM wip_discrete_jobs wdj,
1704: mtl_item_revisions mir
1705: WHERE wdj.organization_id = mir.organization_id
1706: AND wdj.wip_entity_id = wipEntityID
1707: AND mir.organization_id = orgID