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.AMS_DMSELECTION_PVT dependencies on OE_ORDER_LINES_ALL

Line 2151: FROM AMS_ACT_PRODUCTS aa, OE_ORDER_HEADERS_ALL oh, OE_ORDER_LINES_ALL ol,

2147: UPDATE ams_dm_target_stg_gt t
2148: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2149: FROM dual
2150: WHERE EXISTS (SELECT 1
2151: FROM AMS_ACT_PRODUCTS aa, OE_ORDER_HEADERS_ALL oh, OE_ORDER_LINES_ALL ol,
2152: hz_cust_account_roles hcr, hz_relationships hpr
2153: WHERE aa.ARC_ACT_PRODUCT_USED_BY = 'MODL'
2154: and aa.ACT_PRODUCT_USED_BY_ID = p_model_id
2155: and ol.INVENTORY_ITEM_ID IN

Line 2190: OE_ORDER_LINES_ALL ol,

2186: FROM dual
2187: WHERE EXISTS (SELECT 1
2188: FROM AMS_ACT_PRODUCTS aa,
2189: OE_ORDER_HEADERS_ALL oh,
2190: OE_ORDER_LINES_ALL ol,
2191: --hz_cust_site_uses_all hcsu,
2192: --hz_cust_acct_sites_all hcs,
2193: HZ_CUST_ACCOUNTS hc
2194: WHERE aa.ARC_ACT_PRODUCT_USED_BY = 'MODL'