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.HZ_EXTRACT_PARTY_SITE_BO_PVT dependencies on HZ_EXTRACT_BO_UTIL_PVT

Line 94: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PS.PARTY_ID),

90: NULL, -- COMMON_OBJ_ID
91: PS.PARTY_SITE_ID,
92: NULL, --PS.ORIG_SYSTEM,
93: NULL, --PS.ORIG_SYSTEM_REFERENCE,
94: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PS.PARTY_ID),
95: PS.PARTY_ID,
96: PS.PARTY_SITE_NUMBER,
97: PS.MAILSTOP,
98: PS.IDENTIFYING_ADDRESS_FLAG,

Line 126: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PS.CREATED_BY),

122: PS.LANGUAGE,
123: PS.ADDRESSEE,
124: PS.PROGRAM_UPDATE_DATE,
125: PS.CREATED_BY_MODULE,
126: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PS.CREATED_BY),
127: PS.CREATION_DATE,
128: PS.LAST_UPDATE_DATE,
129: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PS.LAST_UPDATED_BY),
130: PS.ACTUAL_CONTENT_SOURCE,

Line 129: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PS.LAST_UPDATED_BY),

125: PS.CREATED_BY_MODULE,
126: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PS.CREATED_BY),
127: PS.CREATION_DATE,
128: PS.LAST_UPDATE_DATE,
129: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PS.LAST_UPDATED_BY),
130: PS.ACTUAL_CONTENT_SOURCE,
131: PS.GLOBAL_LOCATION_NUMBER,
132: CAST(MULTISET (
133: SELECT HZ_ORIG_SYS_REF_OBJ(

Line 138: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),

134: NULL, --P_ACTION_TYPE,
135: ORIG_SYSTEM_REF_ID,
136: ORIG_SYSTEM,
137: ORIG_SYSTEM_REFERENCE,
138: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type(OWNER_TABLE_NAME,OWNER_TABLE_ID),
139: OWNER_TABLE_ID,
140: STATUS,
141: REASON_CODE,
142: OLD_ORIG_SYSTEM_REFERENCE,

Line 147: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

143: START_DATE_ACTIVE,
144: END_DATE_ACTIVE,
145: PROGRAM_UPDATE_DATE,
146: CREATED_BY_MODULE,
147: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
148: CREATION_DATE,
149: LAST_UPDATE_DATE,
150: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
151: ATTRIBUTE_CATEGORY,

Line 150: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

146: CREATED_BY_MODULE,
147: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
148: CREATION_DATE,
149: LAST_UPDATE_DATE,
150: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
151: ATTRIBUTE_CATEGORY,
152: ATTRIBUTE1,
153: ATTRIBUTE2,
154: ATTRIBUTE3,

Line 242: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LOC.CREATED_BY),

238: LOC.ATTRIBUTE19,
239: LOC.ATTRIBUTE20,
240: LOC.PROGRAM_UPDATE_DATE,
241: LOC.CREATED_BY_MODULE,
242: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LOC.CREATED_BY),
243: LOC.CREATION_DATE,
244: LOC.LAST_UPDATE_DATE,
245: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LOC.LAST_UPDATED_BY),
246: LOC.ACTUAL_CONTENT_SOURCE,

Line 245: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LOC.LAST_UPDATED_BY),

241: LOC.CREATED_BY_MODULE,
242: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LOC.CREATED_BY),
243: LOC.CREATION_DATE,
244: LOC.LAST_UPDATE_DATE,
245: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LOC.LAST_UPDATED_BY),
246: LOC.ACTUAL_CONTENT_SOURCE,
247: LOC.DELIVERY_POINT_CODE,
248: LOC.GEOMETRY_STATUS_CODE,
249: LOC.GEOMETRY,

Line 265: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

261: PRIMARY_PER_TYPE,
262: STATUS,
263: PROGRAM_UPDATE_DATE,
264: CREATED_BY_MODULE,
265: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
266: CREATION_DATE,
267: LAST_UPDATE_DATE,
268: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
269: FROM HZ_PARTY_SITE_USES

Line 268: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

264: CREATED_BY_MODULE,
265: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
266: CREATION_DATE,
267: LAST_UPDATE_DATE,
268: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
269: FROM HZ_PARTY_SITE_USES
270: WHERE PARTY_SITE_ID = PS.PARTY_SITE_ID) AS HZ_PARTY_SITE_USE_OBJ_TBL),
271: HZ_PHONE_CP_BO_TBL(),
272: HZ_TELEX_CP_BO_TBL(),

Line 300: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

296: REASON_CODE,
297: STATUS,
298: PROGRAM_UPDATE_DATE,
299: CREATED_BY_MODULE,
300: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
301: CREATION_DATE,
302: LAST_UPDATE_DATE,
303: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
304: FROM HZ_CONTACT_PREFERENCES CPREF

Line 303: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

299: CREATED_BY_MODULE,
300: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
301: CREATION_DATE,
302: LAST_UPDATE_DATE,
303: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
304: FROM HZ_CONTACT_PREFERENCES CPREF
305: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTY_SITES'
306: AND CONTACT_LEVEL_TABLE_ID = PS.PARTY_SITE_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
307: FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC WHERE PS.LOCATION_ID = LOC.LOCATION_ID