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.IEC_SUBSET_PVT dependencies on IEC_O_RCY_CALL_HISTORIES

Line 1578: , IEC_O_RCY_CALL_HISTORIES B

1574: , a.returns_id RETURNS_ID
1575: , a.do_not_use_flag DO_NOT_USE_FLAG
1576: , DECODE(NVL(SUM(B.CALL_ATTEMPT), 0), 0, 0, 1) CALLED_ONCE
1577: from iec_g_return_entries a
1578: , IEC_O_RCY_CALL_HISTORIES B
1579: where a.LIST_HEADER_ID = P_TARGET_GROUP_ID
1580: and a.pulled_subset_id IS NOT NULL
1581: and a.returns_id = b.returns_id(+)
1582: group by a.subset_id

Line 2139: ' FROM IEC_G_RETURN_ENTRIES A, IEC_O_RCY_CALL_HISTORIES B ' ||

2135: ') ' ||
2136: 'SELECT A.LIST_HEADER_ID, A.LIST_ENTRY_ID, A.SUBSET_ID, A.PULLED_SUBSET_ID ' ||
2137: ', A.ITM_CC_TZ_ID, NULL, A.DO_NOT_USE_FLAG, ''N'', A.RETURNS_ID, ' ||
2138: ' DECODE(NVL(SUM(B.CALL_ATTEMPT), 0), 0, 0, 1) ' ||
2139: ' FROM IEC_G_RETURN_ENTRIES A, IEC_O_RCY_CALL_HISTORIES B ' ||
2140: ' WHERE A.SUBSET_ID = :oldSubsetId ' ||
2141: ' AND A.RETURNS_ID = B.RETURNS_ID(+) ' ||
2142: ' AND A.PULLED_SUBSET_ID = :newSubsetId' ||
2143: ' AND A.RECORD_OUT_FLAG = ''N'' GROUP BY ' ||