DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on WIP_DISCRETE_JOBS

Line 3663: FROM wip_discrete_jobs

3659: CURSOR all_job_cur(p_source_line_id IN number) IS
3660: SELECT wip_entity_id,
3661: organization_id,
3662: request_id
3663: FROM wip_discrete_jobs
3664: WHERE primary_item_id = p_config_rec.item_id
3665: AND organization_id = p_config_rec.ship_organization_id
3666: AND source_line_id = p_source_line_id
3667: AND status_type <> 7 -- excluding the cancelled wip jobs

Line 3763: FROM wip_discrete_jobs

3759: SELECT wip_entity_id,
3760: organization_id
3761: INTO l_config_rec.sub_config_wip_job_id,
3762: l_config_rec.sub_config_wip_org_id
3763: FROM wip_discrete_jobs
3764: WHERE primary_item_id = l_config_rec.sub_config_item_id
3765: AND request_id = l_config_rec.request_id
3766: AND rownum = 1;
3767: l_config_rec.sub_config_make_flag := 'Y';