eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPVLDT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 999: FROM bom_operational_routings bor,

995: bor.completion_locator_id /*ST bug 3336844 ) */ -- BBK- Bug#2795951
996: -- NULL) -- CZH.BUG2398718
997: -- This is for other locator types like Dynamic Entry (3) and
998: -- Item level control (4), which are not supported by OSFM.
999: FROM bom_operational_routings bor,
1000: mtl_secondary_inventories msi -- CZH.BUG2398718
1001: WHERE bor.common_routing_sequence_id = rj.common_routing_sequence_id
1002: AND bor.organization_id = rj.organization_id
1003: --VJ: Start Changes for NSLBJ--

Line 2879: from bom_operational_routings bor

2875: UPDATE wsm_starting_jobs_interface wsji
2876: SET wsji.error_message = l_fnd_generic_err_msg
2877: WHERE wsji.header_id = l_header_id
2878: and NOT EXISTS (select 1
2879: from bom_operational_routings bor
2880: where bor.routing_sequence_id = l_cur_wsji_rec.routing_seq_id
2881: and ((bor.assembly_item_id = l_cur_wsji_rec.primary_item_id
2882: and l_wsji_job_type = WIP_CONSTANTS.STANDARD) -- Bug#2679705
2883: OR

Line 5313: from bom_operational_routings bor

5309: l_stmt_num := 128;
5310: UPDATE wsm_resulting_jobs_interface wrji
5311: SET common_routing_sequence_id=
5312: (select bor.common_routing_sequence_id
5313: from bom_operational_routings bor
5314: where bor.assembly_item_id = decode(wrji.job_type,
5315: WIP_CONSTANTS.STANDARD, wrji.primary_item_id,
5316: wrji.routing_reference_id) -- Fix for bug #2369822
5317: and bor.alternate_routing_designator is null

Line 5351: from bom_operational_routings bor

5347: WHERE wrji.header_id = l_header_id
5348: AND wrji.rowid = l_wrji_rowid --SpUA add
5349: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5350: AND NOT EXISTS (select 1
5351: from bom_operational_routings bor
5352: where bor.routing_sequence_id = wrji.common_routing_sequence_id
5353: and bor.alternate_routing_designator = wrji.alternate_routing_designator
5354: --and bor.assembly_item_id=wrji.primary_item_id --bugfix 2077930
5355: and bor.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn

Line 5389: from bom_operational_routings bor

5385: WHERE wrji.header_id = l_header_id
5386: AND wrji.rowid = l_wrji_rowid --SpUA add
5387: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5388: AND NOT EXISTS (select 1
5389: from bom_operational_routings bor
5390: where bor.routing_sequence_id = wrji.common_routing_sequence_id
5391: --and bor.assembly_item_id=wrji.primary_item_id --bugfix 2077930
5392: and bor.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn
5393: and bor.cfm_routing_flag=3);

Line 5400: from bom_operational_routings bor

5396: l_stmt_num := 131;
5397: UPDATE wsm_resulting_jobs_interface wrji
5398: SET wrji.alternate_routing_designator =
5399: (select bor.alternate_routing_designator
5400: from bom_operational_routings bor
5401: where bor.routing_sequence_id = wrji.common_routing_sequence_id
5402: --and bor.assembly_item_id=wrji.primary_item_id --bugfix 2077930
5403: and bor.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn
5404: and bor.cfm_routing_flag=3)

Line 5459: from bom_operational_routings bor

5455: WHERE wrji.header_id = l_header_id
5456: AND wrji.rowid = l_wrji_rowid --SpUA add
5457: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5458: AND NOT EXISTS (select 1
5459: from bom_operational_routings bor
5460: where bor.alternate_routing_designator = wrji.alternate_routing_designator
5461: and bor.assembly_item_id = wrji.primary_item_id
5462: and bor.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn
5463: and bor.cfm_routing_flag=3);

Line 5470: from bom_operational_routings bor

5466: l_stmt_num := 133;
5467: UPDATE wsm_resulting_jobs_interface wrji
5468: SET wrji.common_routing_sequence_id =
5469: (select bor.common_routing_sequence_id
5470: from bom_operational_routings bor
5471: where bor.alternate_routing_designator = wrji.alternate_routing_designator
5472: and bor.assembly_item_id = wrji.primary_item_id
5473: and bor.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn
5474: and bor.cfm_routing_flag=3)

Line 5621: FROM bom_operational_routings bor,

5617: bor.completion_locator_id /*bug 3336844 )*/ -- BBK- Bug#2795951
5618: -- NULL) -- CZH.BUG2398718
5619: -- This is for other locator types like Dynamic Entry (3) and
5620: -- Item level control (4), which are not supported by OSFM.
5621: FROM bom_operational_routings bor,
5622: mtl_secondary_inventories msi -- CZH.BUG2398718
5623: WHERE bor.common_routing_sequence_id = rj.common_routing_sequence_id
5624: AND bor.organization_id = rj.organization_id
5625: AND bor.assembly_item_id = decode(rj.job_type,

Line 7168: bom_operational_routings bor,

7164: l_start_std_op_id
7165: , l_organization_id
7166: , l_sj_intraoperation_step
7167: from
7168: bom_operational_routings bor,
7169: wsm_resulting_jobs_interface wrji,
7170: wsm_starting_jobs_interface wsji
7171: where
7172: bor.assembly_item_id = wrji.primary_item_id