DBA Data[Home] [Help]

APPS.CSI_UTL_PKG dependencies on WIP_DISCRETE_JOBS

Line 2367: FROM wip_discrete_jobs

2363: BEGIN
2364:
2365: SELECT wip_entity_id
2366: INTO l_wip_job_id
2367: FROM wip_discrete_jobs
2368: WHERE primary_item_id = p_order_line_rec.inv_item_id
2369: AND organization_id = p_order_line_rec.inv_org_id
2370: AND source_line_id = p_order_line_rec.order_line_id
2371: AND status_type <> 7; -- exclude the cancelled job