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.AHL_LTP_MTL_REQ_PVT dependencies on AHL_SB_RULE_ITEMS

Line 2461: FROM ahl_sb_rule_items

2457: AND ia.interchange_type_code = '2-WAY INTERCHANGEABLE'
2458: AND ia.inventory_item_id = msi.inventory_item_id
2459: AND msi.organization_id = NVL(p_visit_org_id, ia.inventory_org_id)
2460: AND ia.item_association_id IN (SELECT item_association_id
2461: FROM ahl_sb_rule_items
2462: WHERE rule_id = p_rule_id
2463: AND item_group_id = p_item_group_id)
2464: ORDER BY ia.priority;
2465:

Line 2674: FROM ahl_sb_rule_items

2670: AND ia.inventory_item_id = msi.inventory_item_id
2671: AND msi.organization_id = c_organization_id
2672: AND ia.inventory_item_id <> nvl(c_inventory_item_id, -1)
2673: AND ia.item_association_id IN (SELECT item_association_id
2674: FROM ahl_sb_rule_items
2675: WHERE rule_id = c_sb_rule_id
2676: AND item_group_id = mcr.item_group_id)
2677: UNION
2678: SELECT ia.inventory_item_id,

Line 2691: FROM ahl_sb_rule_items

2687: AND ia.inventory_item_id = msi.inventory_item_id
2688: AND msi.organization_id = c_organization_id
2689: AND ia.inventory_item_id <> nvl(c_inventory_item_id, -1)
2690: AND ia.item_association_id IN (SELECT item_association_id
2691: FROM ahl_sb_rule_items
2692: WHERE rule_id = c_sb_rule_id
2693: AND item_group_id = mcr.item_group_id)
2694: order by smc_priority, item_priority;
2695: