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

Line 3271: bom_operational_routings bor

3267:
3268: select NVL(cfm_routing_flag,2)
3269: into l_supply_type
3270: from oe_order_lines_all oel,
3271: bom_operational_routings bor
3272: where oel.line_id = to_number(p_itemkey)
3273: and oel.inventory_item_id = bor.assembly_item_id (+)
3274: and oel.ship_from_org_id = bor.organization_id (+)
3275: and bor.alternate_routing_designator (+) is NULL;

Line 3410: from bom_operational_routings bor

3406: into l_quantity
3407: from oe_order_lines_all oel
3408: where oel.line_id = to_number(p_itemkey)
3409: and exists (select '1'
3410: from bom_operational_routings bor
3411: where bor.assembly_item_id = oel.inventory_item_id
3412: and bor.organization_id = oel.ship_from_org_id
3413: and bor.alternate_routing_designator is null
3414: and nvl(bor.cfm_routing_flag, 2) = 1)

Line 3804: from bom_operational_routings bor

3800: not in (0,1)
3801: )
3802: and not exists
3803: (select '1'
3804: from bom_operational_routings bor
3805: where bor.assembly_item_id = oel.inventory_item_id
3806: and bor.organization_id = oel.ship_from_org_id
3807: and bor.alternate_routing_designator is null
3808: and nvl(bor.cfm_routing_flag, 2) = 1)