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 3238: bom_operational_routings bor

3234:
3235: select NVL(cfm_routing_flag,2)
3236: into l_supply_type
3237: from oe_order_lines_all oel,
3238: bom_operational_routings bor
3239: where oel.line_id = to_number(p_itemkey)
3240: and oel.inventory_item_id = bor.assembly_item_id (+)
3241: and oel.ship_from_org_id = bor.organization_id (+)
3242: and bor.alternate_routing_designator (+) is NULL;

Line 3377: from bom_operational_routings bor

3373: into l_quantity
3374: from oe_order_lines_all oel
3375: where oel.line_id = to_number(p_itemkey)
3376: and exists (select '1'
3377: from bom_operational_routings bor
3378: where bor.assembly_item_id = oel.inventory_item_id
3379: and bor.organization_id = oel.ship_from_org_id
3380: and bor.alternate_routing_designator is null
3381: and nvl(bor.cfm_routing_flag, 2) = 1)

Line 3771: from bom_operational_routings bor

3767: not in (0,1)
3768: )
3769: and not exists
3770: (select '1'
3771: from bom_operational_routings bor
3772: where bor.assembly_item_id = oel.inventory_item_id
3773: and bor.organization_id = oel.ship_from_org_id
3774: and bor.alternate_routing_designator is null
3775: and nvl(bor.cfm_routing_flag, 2) = 1)