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.WSMPLBJI dependencies on BOM_OPERATIONAL_ROUTINGS

Line 2026: FROM BOM_OPERATIONAL_ROUTINGS BOR

2022: end if;
2023:
2024: l_stat_num := 90.5;
2025: SELECT common_routing_sequence_id INTO l_routing_seq_id
2026: FROM BOM_OPERATIONAL_ROUTINGS BOR
2027: WHERE BOR.assembly_item_id= decode(p_job_type,1,p_assembly_item_id,p_rtg_reference_id)
2028: AND nvl(BOR.alternate_routing_designator, '***') = nvl(p_alt_rtg_designator, '***')
2029: and bor.organization_id = p_organization_id;
2030:

Line 4018: from bom_operational_routings bor,

4014: into routing_seq_id,
4015: l_default_subinventory,
4016: l_default_compl_loc_id
4017: --from bom_routing_alternates_v bor
4018: from bom_operational_routings bor,
4019: bom_alternate_designators bad
4020: where ((bor.alternate_routing_designator is null and
4021: bad.alternate_designator_code is null
4022: and bad.organization_id = -1)

Line 5605: from bom_operational_routings bor, bom_alternate_designators bad

5601: bor.COMPLETION_LOCATOR_ID
5602: into p_common_routing_sequence_id,
5603: l_default_subinventory,
5604: l_default_compl_loc_id
5605: from bom_operational_routings bor, bom_alternate_designators bad
5606: where ((bor.alternate_routing_designator is null and bad.alternate_designator_code is null
5607: and bad.organization_id = -1)
5608: or (bor.alternate_routing_designator = bad.alternate_designator_code
5609: and bor.organization_id = bad.organization_id))