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_CUST_SITE_USES_PKG dependencies on HZ_UTILITY_V2PUB

Line 236: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

232: )
233: VALUES (
234: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_CUST_SITE_USES_S.NEXTVAL, NULL, HZ_CUST_SITE_USES_S.NEXTVAL, X_SITE_USE_ID ),
235: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
236: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
237: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
238: HZ_UTILITY_V2PUB.CREATION_DATE,
239: HZ_UTILITY_V2PUB.CREATED_BY,
240: DECODE( X_SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),

Line 237: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

233: VALUES (
234: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_CUST_SITE_USES_S.NEXTVAL, NULL, HZ_CUST_SITE_USES_S.NEXTVAL, X_SITE_USE_ID ),
235: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
236: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
237: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
238: HZ_UTILITY_V2PUB.CREATION_DATE,
239: HZ_UTILITY_V2PUB.CREATED_BY,
240: DECODE( X_SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
241: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),

Line 238: HZ_UTILITY_V2PUB.CREATION_DATE,

234: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_CUST_SITE_USES_S.NEXTVAL, NULL, HZ_CUST_SITE_USES_S.NEXTVAL, X_SITE_USE_ID ),
235: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
236: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
237: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
238: HZ_UTILITY_V2PUB.CREATION_DATE,
239: HZ_UTILITY_V2PUB.CREATED_BY,
240: DECODE( X_SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
241: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
242: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 239: HZ_UTILITY_V2PUB.CREATED_BY,

235: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
236: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
237: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
238: HZ_UTILITY_V2PUB.CREATION_DATE,
239: HZ_UTILITY_V2PUB.CREATED_BY,
240: DECODE( X_SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
241: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
242: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
243: DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),

Line 244: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

240: DECODE( X_SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
241: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
242: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
243: DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),
244: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
245: DECODE( X_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_ID ),
246: DECODE( X_BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_BILL_TO_SITE_USE_ID ),
247: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
248: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),

Line 270: HZ_UTILITY_V2PUB.REQUEST_ID,

266: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
267: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
268: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
269: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
270: HZ_UTILITY_V2PUB.REQUEST_ID,
271: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
272: HZ_UTILITY_V2PUB.PROGRAM_ID,
273: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
274: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

Line 271: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

267: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
268: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
269: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
270: HZ_UTILITY_V2PUB.REQUEST_ID,
271: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
272: HZ_UTILITY_V2PUB.PROGRAM_ID,
273: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
274: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
275: DECODE( X_SORT_PRIORITY, FND_API.G_MISS_NUM, NULL, X_SORT_PRIORITY ),

Line 272: HZ_UTILITY_V2PUB.PROGRAM_ID,

268: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
269: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
270: HZ_UTILITY_V2PUB.REQUEST_ID,
271: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
272: HZ_UTILITY_V2PUB.PROGRAM_ID,
273: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
274: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
275: DECODE( X_SORT_PRIORITY, FND_API.G_MISS_NUM, NULL, X_SORT_PRIORITY ),
276: DECODE( X_TAX_CODE, FND_API.G_MISS_CHAR, NULL, X_TAX_CODE ),

Line 273: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

269: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
270: HZ_UTILITY_V2PUB.REQUEST_ID,
271: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
272: HZ_UTILITY_V2PUB.PROGRAM_ID,
273: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
274: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
275: DECODE( X_SORT_PRIORITY, FND_API.G_MISS_NUM, NULL, X_SORT_PRIORITY ),
276: DECODE( X_TAX_CODE, FND_API.G_MISS_CHAR, NULL, X_TAX_CODE ),
277: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 500: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

496:
497: UPDATE HZ_CUST_SITE_USES_ALL SET
498: SITE_USE_ID = DECODE( X_SITE_USE_ID, NULL, SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
499: CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
500: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
501: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
502: CREATION_DATE = CREATION_DATE,
503: CREATED_BY = CREATED_BY,
504: SITE_USE_CODE = DECODE( X_SITE_USE_CODE, NULL, SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),

Line 501: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

497: UPDATE HZ_CUST_SITE_USES_ALL SET
498: SITE_USE_ID = DECODE( X_SITE_USE_ID, NULL, SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
499: CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
500: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
501: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
502: CREATION_DATE = CREATION_DATE,
503: CREATED_BY = CREATED_BY,
504: SITE_USE_CODE = DECODE( X_SITE_USE_CODE, NULL, SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
505: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),

Line 508: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

504: SITE_USE_CODE = DECODE( X_SITE_USE_CODE, NULL, SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
505: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
506: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
507: LOCATION = DECODE( X_LOCATION, NULL, LOCATION, FND_API.G_MISS_CHAR, NULL, X_LOCATION ),
508: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
509: CONTACT_ID = DECODE( X_CONTACT_ID, NULL, CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_ID),
510: BILL_TO_SITE_USE_ID = DECODE( X_BILL_TO_SITE_USE_ID, NULL, BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_BILL_TO_SITE_USE_ID ),
511: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
512: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),

Line 534: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

530: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
531: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
532: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
533: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
534: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
535: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
536: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
537: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
538: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

Line 535: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

531: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
532: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
533: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
534: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
535: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
536: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
537: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
538: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
539: SORT_PRIORITY = DECODE( X_SORT_PRIORITY, NULL, SORT_PRIORITY, FND_API.G_MISS_NUM, NULL, X_SORT_PRIORITY ),

Line 536: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

532: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
533: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
534: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
535: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
536: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
537: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
538: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
539: SORT_PRIORITY = DECODE( X_SORT_PRIORITY, NULL, SORT_PRIORITY, FND_API.G_MISS_NUM, NULL, X_SORT_PRIORITY ),
540: TAX_CODE = DECODE( X_TAX_CODE, NULL, TAX_CODE, FND_API.G_MISS_CHAR, NULL, X_TAX_CODE ),

Line 537: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

533: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
534: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
535: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
536: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
537: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
538: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
539: SORT_PRIORITY = DECODE( X_SORT_PRIORITY, NULL, SORT_PRIORITY, FND_API.G_MISS_NUM, NULL, X_SORT_PRIORITY ),
540: TAX_CODE = DECODE( X_TAX_CODE, NULL, TAX_CODE, FND_API.G_MISS_CHAR, NULL, X_TAX_CODE ),
541: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),