DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on BOM_OPERATIONAL_ROUTINGS

Line 475: FROM BOM_OPERATIONAL_ROUTINGS R,

471: to_char(SEQ.OPERATION_YIELD_ENABLED),
472: DJ.QUANTITY_SCRAPPED,
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)

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: