DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on WIP_DISCRETE_JOBS

Line 3711: FROM wip_discrete_jobs

3707: CURSOR all_job_cur(p_source_line_id IN number) IS
3708: SELECT wip_entity_id,
3709: organization_id,
3710: request_id
3711: FROM wip_discrete_jobs
3712: WHERE primary_item_id = p_config_rec.item_id
3713: AND organization_id = p_config_rec.ship_organization_id
3714: AND source_line_id = p_source_line_id
3715: AND status_type <> 7 -- excluding the cancelled wip jobs

Line 3811: FROM wip_discrete_jobs

3807: SELECT wip_entity_id,
3808: organization_id
3809: INTO l_config_rec.sub_config_wip_job_id,
3810: l_config_rec.sub_config_wip_org_id
3811: FROM wip_discrete_jobs
3812: WHERE primary_item_id = l_config_rec.sub_config_item_id
3813: AND request_id = l_config_rec.request_id
3814: AND rownum = 1;
3815: l_config_rec.sub_config_make_flag := 'Y';