DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on WIP_DISCRETE_JOBS

Line 6920: FROM wip_discrete_jobs

6916: BEGIN
6917:
6918: SELECT wip_entity_id
6919: INTO l_wip_job_id
6920: FROM wip_discrete_jobs
6921: WHERE primary_item_id = l_order_line_rec.inv_item_id
6922: AND organization_id = l_order_line_rec.inv_org_id
6923: AND source_line_id = l_order_line_rec.order_line_id
6924: AND status_type <> 7; -- excluding the cancelled wip jobs