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_ACCT_SITE_BO_PVT dependencies on HZ_EXTRACT_BO_UTIL_PVT

Line 121: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

117: AUTOCASH_HIERARCHY_ID_FOR_ADR,
118: LOCKBOX_MATCHING_OPTION,
119: PROGRAM_UPDATE_DATE,
120: CREATED_BY_MODULE,
121: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
122: CREATION_DATE,
123: LAST_UPDATE_DATE,
124: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
125: REVIEW_CYCLE,

Line 124: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

120: CREATED_BY_MODULE,
121: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
122: CREATION_DATE,
123: LAST_UPDATE_DATE,
124: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
125: REVIEW_CYCLE,
126: LAST_CREDIT_REVIEW_DATE,
127: CREDIT_CLASSIFICATION,
128: CONS_BILL_LEVEL,

Line 214: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

210: GLOBAL_ATTRIBUTE20,
211: GLOBAL_ATTRIBUTE_CATEGORY,
212: PROGRAM_UPDATE_DATE,
213: CREATED_BY_MODULE,
214: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
215: CREATION_DATE,
216: LAST_UPDATE_DATE,
217: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
218: EXCHANGE_RATE_TYPE,

Line 217: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

213: CREATED_BY_MODULE,
214: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
215: CREATION_DATE,
216: LAST_UPDATE_DATE,
217: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
218: EXCHANGE_RATE_TYPE,
219: MIN_FC_INVOICE_OVERDUE_TYPE,
220: MIN_FC_INVOICE_PERCENT,
221: MIN_FC_BALANCE_OVERDUE_TYPE,

Line 463: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.CREATED_BY),

459: CSU.TAX_CLASSIFICATION,
460: CSU.ORG_ID,
461: CSU.PROGRAM_UPDATE_DATE,
462: CSU.CREATED_BY_MODULE,
463: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.CREATED_BY),
464: CSU.CREATION_DATE,
465: CSU.LAST_UPDATE_DATE,
466: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),
467: CAST(MULTISET (

Line 466: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),

462: CSU.CREATED_BY_MODULE,
463: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.CREATED_BY),
464: CSU.CREATION_DATE,
465: CSU.LAST_UPDATE_DATE,
466: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),
467: CAST(MULTISET (
468: SELECT HZ_ORIG_SYS_REF_OBJ(
469: NULL, --P_ACTION_TYPE,
470: ORIG_SYSTEM_REF_ID,

Line 482: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

478: START_DATE_ACTIVE,
479: END_DATE_ACTIVE,
480: PROGRAM_UPDATE_DATE,
481: CREATED_BY_MODULE,
482: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
483: CREATION_DATE,
484: LAST_UPDATE_DATE,
485: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
486: ATTRIBUTE_CATEGORY,

Line 485: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

481: CREATED_BY_MODULE,
482: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
483: CREATION_DATE,
484: LAST_UPDATE_DATE,
485: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
486: ATTRIBUTE_CATEGORY,
487: ATTRIBUTE1,
488: ATTRIBUTE2,
489: ATTRIBUTE3,

Line 528: NULL, --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

524: INSTRUMENT_TYPE,
525: ORDER_OF_PREFERENCE,
526: ASSIGNMENT_START_DATE,
527: ASSIGNMENT_END_DATE,
528: NULL, --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
529: NULL, --CREATION_DATE,
530: ASSIGNMENT_LAST_UPDATE,
531: NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
532: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 531: NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

527: ASSIGNMENT_END_DATE,
528: NULL, --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
529: NULL, --CREATION_DATE,
530: ASSIGNMENT_LAST_UPDATE,
531: NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
532: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
533: WHERE ACCT_SITE_USE_ID = CSU.SITE_USE_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
534: ( SELECT HZ_PAYMENT_METHOD_OBJ(
535: P_ACTION_TYPE,

Line 560: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),

556: CRM.ATTRIBUTE12,
557: CRM.ATTRIBUTE13,
558: CRM.ATTRIBUTE14,
559: CRM.ATTRIBUTE15,
560: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
561: CRM.CREATION_DATE,
562: CRM.LAST_UPDATE_DATE,
563: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
564: FROM RA_CUST_RECEIPT_METHODS CRM

Line 563: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))

559: CRM.ATTRIBUTE15,
560: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
561: CRM.CREATION_DATE,
562: CRM.LAST_UPDATE_DATE,
563: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
564: FROM RA_CUST_RECEIPT_METHODS CRM
565: WHERE CSU.SITE_USE_ID = CRM.SITE_USE_ID
566: AND ROWNUM = 1)
567: )

Line 836: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

832: TRANSLATED_CUSTOMER_NAME,
833: ORG_ID,
834: PROGRAM_UPDATE_DATE,
835: CREATED_BY_MODULE,
836: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
837: CREATION_DATE,
838: LAST_UPDATE_DATE,
839: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
840: PARTY_SITE_ID,

Line 839: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

835: CREATED_BY_MODULE,
836: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
837: CREATION_DATE,
838: LAST_UPDATE_DATE,
839: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
840: PARTY_SITE_ID,
841: NULL, --PARTY_SITE_OS,
842: NULL, --PARTY_SITE_OSR,
843: CAST(MULTISET (

Line 858: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

854: START_DATE_ACTIVE,
855: END_DATE_ACTIVE,
856: PROGRAM_UPDATE_DATE,
857: CREATED_BY_MODULE,
858: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
859: CREATION_DATE,
860: LAST_UPDATE_DATE,
861: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
862: ATTRIBUTE_CATEGORY,

Line 861: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

857: CREATED_BY_MODULE,
858: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
859: CREATION_DATE,
860: LAST_UPDATE_DATE,
861: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
862: ATTRIBUTE_CATEGORY,
863: ATTRIBUTE1,
864: ATTRIBUTE2,
865: ATTRIBUTE3,

Line 903: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

899: START_DATE_ACTIVE,
900: END_DATE_ACTIVE,
901: PROGRAM_UPDATE_DATE,
902: CREATED_BY_MODULE,
903: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
904: CREATION_DATE,
905: LAST_UPDATE_DATE,
906: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
907: ATTRIBUTE_CATEGORY,

Line 906: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

902: CREATED_BY_MODULE,
903: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
904: CREATION_DATE,
905: LAST_UPDATE_DATE,
906: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
907: ATTRIBUTE_CATEGORY,
908: ATTRIBUTE1,
909: ATTRIBUTE2,
910: ATTRIBUTE3,

Line 1209: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.CREATED_BY),

1205: CSU.TAX_CLASSIFICATION,
1206: CSU.ORG_ID,
1207: CSU.PROGRAM_UPDATE_DATE,
1208: CSU.CREATED_BY_MODULE,
1209: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.CREATED_BY),
1210: CSU.CREATION_DATE,
1211: CSU.LAST_UPDATE_DATE,
1212: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),
1213: CAST(MULTISET (

Line 1212: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),

1208: CSU.CREATED_BY_MODULE,
1209: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.CREATED_BY),
1210: CSU.CREATION_DATE,
1211: CSU.LAST_UPDATE_DATE,
1212: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),
1213: CAST(MULTISET (
1214: SELECT HZ_ORIG_SYS_REF_OBJ(
1215: NULL, --P_ACTION_TYPE,
1216: ORIG_SYSTEM_REF_ID,

Line 1228: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1224: START_DATE_ACTIVE,
1225: END_DATE_ACTIVE,
1226: PROGRAM_UPDATE_DATE,
1227: CREATED_BY_MODULE,
1228: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1229: CREATION_DATE,
1230: LAST_UPDATE_DATE,
1231: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1232: ATTRIBUTE_CATEGORY,

Line 1231: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1227: CREATED_BY_MODULE,
1228: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1229: CREATION_DATE,
1230: LAST_UPDATE_DATE,
1231: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1232: ATTRIBUTE_CATEGORY,
1233: ATTRIBUTE1,
1234: ATTRIBUTE2,
1235: ATTRIBUTE3,

Line 1274: NULL, --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1270: INSTRUMENT_TYPE,
1271: ORDER_OF_PREFERENCE,
1272: ASSIGNMENT_START_DATE,
1273: ASSIGNMENT_END_DATE,
1274: NULL, --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1275: NULL, --CREATION_DATE,
1276: ASSIGNMENT_LAST_UPDATE,
1277: NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1278: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 1277: NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

1273: ASSIGNMENT_END_DATE,
1274: NULL, --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1275: NULL, --CREATION_DATE,
1276: ASSIGNMENT_LAST_UPDATE,
1277: NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1278: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1279: WHERE ACCT_SITE_USE_ID = CSU.SITE_USE_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
1280: CAST( MULTISET (
1281: SELECT HZ_PAYMENT_METHOD_OBJ(

Line 1307: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),

1303: CRM.ATTRIBUTE12,
1304: CRM.ATTRIBUTE13,
1305: CRM.ATTRIBUTE14,
1306: CRM.ATTRIBUTE15,
1307: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
1308: CRM.CREATION_DATE,
1309: CRM.LAST_UPDATE_DATE,
1310: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
1311: FROM RA_CUST_RECEIPT_METHODS CRM

Line 1310: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))

1306: CRM.ATTRIBUTE15,
1307: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
1308: CRM.CREATION_DATE,
1309: CRM.LAST_UPDATE_DATE,
1310: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
1311: FROM RA_CUST_RECEIPT_METHODS CRM
1312: WHERE CSU.SITE_USE_ID = CRM.SITE_USE_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL)
1313: )
1314: FROM HZ_CUST_SITE_USES CSU

Line 1582: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1578: TRANSLATED_CUSTOMER_NAME,
1579: ORG_ID,
1580: PROGRAM_UPDATE_DATE,
1581: CREATED_BY_MODULE,
1582: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1583: CREATION_DATE,
1584: LAST_UPDATE_DATE,
1585: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1586: PARTY_SITE_ID,

Line 1585: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1581: CREATED_BY_MODULE,
1582: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1583: CREATION_DATE,
1584: LAST_UPDATE_DATE,
1585: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1586: PARTY_SITE_ID,
1587: NULL, --PARTY_SITE_OS,
1588: NULL, --PARTY_SITE_OSR,
1589: CAST(MULTISET (

Line 1604: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1600: START_DATE_ACTIVE,
1601: END_DATE_ACTIVE,
1602: PROGRAM_UPDATE_DATE,
1603: CREATED_BY_MODULE,
1604: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1605: CREATION_DATE,
1606: LAST_UPDATE_DATE,
1607: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1608: ATTRIBUTE_CATEGORY,

Line 1607: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1603: CREATED_BY_MODULE,
1604: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1605: CREATION_DATE,
1606: LAST_UPDATE_DATE,
1607: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1608: ATTRIBUTE_CATEGORY,
1609: ATTRIBUTE1,
1610: ATTRIBUTE2,
1611: ATTRIBUTE3,

Line 1649: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1645: START_DATE_ACTIVE,
1646: END_DATE_ACTIVE,
1647: PROGRAM_UPDATE_DATE,
1648: CREATED_BY_MODULE,
1649: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1650: CREATION_DATE,
1651: LAST_UPDATE_DATE,
1652: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1653: ATTRIBUTE_CATEGORY,

Line 1652: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1648: CREATED_BY_MODULE,
1649: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1650: CREATION_DATE,
1651: LAST_UPDATE_DATE,
1652: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1653: ATTRIBUTE_CATEGORY,
1654: ATTRIBUTE1,
1655: ATTRIBUTE2,
1656: ATTRIBUTE3,