APPS.WSMPOPRN dependencies on WIP_DISCRETE_JOBS

Line 300: FROM WIP_DISCRETE_JOBS wdj

296: l_stat_num := 230;
297: --move enh added start_quantity
298: SELECT NVL(ROUTING_REVISION_DATE, SYSDATE), start_quantity
299: INTO p_rtg_rev_date, l_start_quantity
300: FROM WIP_DISCRETE_JOBS wdj
301: WHERE wdj.ORGANIZATION_ID = X_Organization_Id
302: AND wdj.WIP_ENTITY_ID = X_Wip_Entity_Id;
303: -- EA: CZH.I_OED-1
304:

Line 309: WIP_DISCRETE_JOBS wdj

305: l_stat_num := 240;
306: SELECT count(*)
307: INTO l_count
308: FROM BOM_OPERATION_SEQUENCES bos,
309: WIP_DISCRETE_JOBS wdj
310: WHERE wdj.WIP_ENTITY_ID = X_Wip_Entity_Id
311: AND wdj.ORGANIZATION_ID = X_Organization_Id
312: -- AND bos.standard_operation_id = X_Standard_Operation_Id
313: AND bos.operation_sequence_id = X_Op_Seq_Id

Line 477: WIP_DISCRETE_JOBS DJ

473: 0,
474: SEQ.LOWEST_ACCEPTABLE_YIELD
475: FROM BOM_OPERATIONAL_ROUTINGS R,
476: BOM_OPERATION_SEQUENCES SEQ,
477: WIP_DISCRETE_JOBS DJ
478: WHERE SEQ.ROUTING_SEQUENCE_ID =
479: nvl(r.common_routing_sequence_id, r.routing_sequence_id)
480: -- BC: CZH.I_OED-1, should honor routing revision date
481: --AND p_curdate >= SEQ.effectivity_date

Line 679: WIP_DISCRETE_JOBS DJ

675: DJ.QUANTITY_SCRAPPED,
676: 0,
677: BSO.LOWEST_ACCEPTABLE_YIELD
678: FROM BOM_STANDARD_OPERATIONS bso,
679: WIP_DISCRETE_JOBS DJ
680: WHERE DJ.WIP_ENTITY_ID = X_Wip_Entity_Id
681: AND DJ.ORGANIZATION_ID = X_Organization_Id
682: AND bso.Standard_operation_id = X_Standard_Operation_Id;
683:

Line 816: from wip_discrete_jobs

812:
813: l_stat_num := 40.15;
814: select job_type
815: into l_job_type
816: from wip_discrete_jobs
817: where wip_entity_id = x_wip_entity_id;
818:
819: l_stat_num := 40.2;
820: x_error_code := 0;

Line 931: from wip_discrete_jobs

927: l_stat_num := 80;
928:
929: select job_type
930: into l_job_type
931: from wip_discrete_jobs
932: where wip_entity_id = X_Wip_Entity_Id;
933:
934: l_stat_num := 90;
935:

Line 1877: from wip_discrete_jobs

1873: --Fix bug #1504009
1874: IF (p_subinventory IS NULL) THEN
1875: select completion_subinventory
1876: into l_comp_subinv
1877: from wip_discrete_jobs
1878: where wip_entity_id = p_wip_entity_id
1879: and organization_id = p_org_id; -- as part of bugfix 2062110: added orgn_id
1880:
1881: /* ST bug fix 3256834 : check if l_comp_subinv is null get it using the routing sequence id .... */

Line 1887: from wip_discrete_jobs wdj,BOM_OPERATIONAL_ROUTINGS bor

1883: /* Get the completion subinventory of the routing associated with the job */
1884: l_stat_num := 15;
1885: select bor.completion_subinventory
1886: into l_comp_subinv
1887: from wip_discrete_jobs wdj,BOM_OPERATIONAL_ROUTINGS bor
1888: where wdj.wip_entity_id = p_wip_entity_id
1889: and wdj.organization_id = p_org_id
1890: and wdj.common_routing_sequence_id = bor.routing_sequence_id;
1891:

Line 2361: WIP_DISCRETE_JOBS WDJ

2357: WCO.operation_seq_num,
2358: 0,
2359: WCO.LOWEST_ACCEPTABLE_YIELD
2360: FROM WSM_COPY_OPERATIONS WCO,
2361: WIP_DISCRETE_JOBS WDJ
2362: WHERE WCO.wip_entity_id=p_wip_entity_id
2363: AND WCO.organization_id=p_org_id
2364: AND WCO.operation_seq_num = p_to_rtg_op_seq_num
2365: AND WDJ.organization_id = WCO.organization_id

Line 3657: FROM WIP_DISCRETE_JOBS WDJ

3653: l_stmt_num := 10;
3654: UPDATE WIP_OPERATIONS WO
3655: SET cumulative_scrap_quantity =
3656: (SELECT quantity_scrapped
3657: FROM WIP_DISCRETE_JOBS WDJ
3658: WHERE WDJ.wip_entity_id = p_wip_entity_id
3659: AND WDJ.organization_id = p_org_id)
3660: WHERE WO.wip_entity_id = p_wip_entity_id
3661: AND WO.organization_id = p_org_id