DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on WIP_DISCRETE_JOBS

Line 7221: FROM wip_discrete_jobs

7217: BEGIN
7218:
7219: SELECT wip_entity_id
7220: INTO l_wip_job_id
7221: FROM wip_discrete_jobs
7222: WHERE primary_item_id = l_order_line_rec.inv_item_id
7223: AND organization_id = l_order_line_rec.inv_org_id
7224: AND source_line_id = l_order_line_rec.order_line_id
7225: AND status_type <> 7; -- excluding the cancelled wip jobs