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.

[Home] [Help]

APPS.RRS_SITE_INFO dependencies on FND_TIMEZONES_VL

Line 1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,

1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1612: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1613: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1614: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type

Line 1813: ,FND_TIMEZONES_VL Ftv

1809: BULK COLLECT
1810: INTO l_phone_details
1811: FROM
1812: HZ_CONTACT_POINTS HzPuiContactPointPhoneEO
1813: ,FND_TIMEZONES_VL Ftv
1814: WHERE (CONTACT_POINT_TYPE = 'PHONE' and
1815: OWNER_TABLE_NAME = 'HZ_PARTIES' AND OWNER_TABLE_ID = l_site_party_id
1816: AND Ftv.ENABLED_FLAG(+) = 'Y'
1817: AND HzPuiContactPointPhoneEO.TIMEZONE_ID = Ftv.UPGRADE_TZ_ID(+)