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

Line 58: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

54: SHIP_TO_FLAG,
55: ORG_ID,
56: PROGRAM_UPDATE_DATE,
57: CREATED_BY_MODULE,
58: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
59: CREATION_DATE,
60: LAST_UPDATE_DATE,
61: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
62: CAST(MULTISET (

Line 61: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

57: CREATED_BY_MODULE,
58: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
59: CREATION_DATE,
60: LAST_UPDATE_DATE,
61: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
62: CAST(MULTISET (
63: SELECT HZ_ORIG_SYS_REF_OBJ(
64: NULL, --P_ACTION_TYPE,
65: ORIG_SYSTEM_REF_ID,

Line 77: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

73: START_DATE_ACTIVE,
74: END_DATE_ACTIVE,
75: PROGRAM_UPDATE_DATE,
76: CREATED_BY_MODULE,
77: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
78: CREATION_DATE,
79: LAST_UPDATE_DATE,
80: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
81: ATTRIBUTE_CATEGORY,

Line 80: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

76: CREATED_BY_MODULE,
77: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
78: CREATION_DATE,
79: LAST_UPDATE_DATE,
80: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
81: ATTRIBUTE_CATEGORY,
82: ATTRIBUTE1,
83: ATTRIBUTE2,
84: ATTRIBUTE3,

Line 324: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

320: AUTOCASH_HIERARCHY_ID_FOR_ADR,
321: LOCKBOX_MATCHING_OPTION,
322: PROGRAM_UPDATE_DATE,
323: CREATED_BY_MODULE,
324: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
325: CREATION_DATE,
326: LAST_UPDATE_DATE,
327: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
328: REVIEW_CYCLE,

Line 327: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

323: CREATED_BY_MODULE,
324: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
325: CREATION_DATE,
326: LAST_UPDATE_DATE,
327: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
328: REVIEW_CYCLE,
329: LAST_CREDIT_REVIEW_DATE,
330: CREDIT_CLASSIFICATION,
331: CONS_BILL_LEVEL,

Line 417: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

413: GLOBAL_ATTRIBUTE20,
414: GLOBAL_ATTRIBUTE_CATEGORY,
415: PROGRAM_UPDATE_DATE,
416: CREATED_BY_MODULE,
417: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
418: CREATION_DATE,
419: LAST_UPDATE_DATE,
420: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
421: EXCHANGE_RATE_TYPE,

Line 420: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

416: CREATED_BY_MODULE,
417: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
418: CREATION_DATE,
419: LAST_UPDATE_DATE,
420: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
421: EXCHANGE_RATE_TYPE,
422: MIN_FC_INVOICE_OVERDUE_TYPE,
423: MIN_FC_INVOICE_PERCENT,
424: MIN_FC_BALANCE_OVERDUE_TYPE,

Line 629: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_CUST_ACCOUNTS',CA.PARTY_ID),

625: NULL, -- COMMON_OBJ_ID
626: CA.CUST_ACCOUNT_ID,
627: NULL, --ORIG_SYSTEM,
628: NULL, --ORIG_SYSTEM_REFERENCE,
629: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_CUST_ACCOUNTS',CA.PARTY_ID),
630: CA.PARTY_ID,
631: CA.ACCOUNT_NUMBER,
632: CA.ATTRIBUTE_CATEGORY,
633: CA.ATTRIBUTE1,

Line 729: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.CREATED_BY),

725: CA.LAST_BATCH_ID,
726: CA.SELLING_PARTY_ID,
727: CA.PROGRAM_UPDATE_DATE,
728: CA.CREATED_BY_MODULE,
729: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.CREATED_BY),
730: CA.CREATION_DATE,
731: CA.LAST_UPDATE_DATE,
732: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.LAST_UPDATED_BY),
733: CAST(MULTISET (

Line 732: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.LAST_UPDATED_BY),

728: CA.CREATED_BY_MODULE,
729: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.CREATED_BY),
730: CA.CREATION_DATE,
731: CA.LAST_UPDATE_DATE,
732: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.LAST_UPDATED_BY),
733: CAST(MULTISET (
734: SELECT HZ_ORIG_SYS_REF_OBJ(
735: NULL, --P_ACTION_TYPE,
736: ORIG_SYSTEM_REF_ID,

Line 748: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

744: START_DATE_ACTIVE,
745: END_DATE_ACTIVE,
746: PROGRAM_UPDATE_DATE,
747: CREATED_BY_MODULE,
748: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
749: CREATION_DATE,
750: LAST_UPDATE_DATE,
751: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
752: ATTRIBUTE_CATEGORY,

Line 751: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

747: CREATED_BY_MODULE,
748: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
749: CREATION_DATE,
750: LAST_UPDATE_DATE,
751: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
752: ATTRIBUTE_CATEGORY,
753: ATTRIBUTE1,
754: ATTRIBUTE2,
755: ATTRIBUTE3,

Line 798: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

794: INSTRUMENT_TYPE,
795: ORDER_OF_PREFERENCE,
796: ASSIGNMENT_START_DATE,
797: ASSIGNMENT_END_DATE,
798: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
799: CREATION_DATE,
800: ASSIGNMENT_LAST_UPDATE,
801: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
802: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 801: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

797: ASSIGNMENT_END_DATE,
798: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
799: CREATION_DATE,
800: ASSIGNMENT_LAST_UPDATE,
801: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
802: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
803: WHERE CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
804: (SELECT HZ_PAYMENT_METHOD_OBJ(
805: P_ACTION_TYPE,

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

826: CRM.ATTRIBUTE12,
827: CRM.ATTRIBUTE13,
828: CRM.ATTRIBUTE14,
829: CRM.ATTRIBUTE15,
830: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
831: CRM.CREATION_DATE,
832: CRM.LAST_UPDATE_DATE,
833: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
834: FROM RA_CUST_RECEIPT_METHODS CRM

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

829: CRM.ATTRIBUTE15,
830: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
831: CRM.CREATION_DATE,
832: CRM.LAST_UPDATE_DATE,
833: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
834: FROM RA_CUST_RECEIPT_METHODS CRM
835: WHERE CA.CUST_ACCOUNT_ID = CRM.CUSTOMER_ID
836: AND ROWNUM = 1)
837: )

Line 1089: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_CUST_ACCOUNTS',CA.PARTY_ID),

1085: NULL, -- COMMON_OBJ_ID
1086: CA.CUST_ACCOUNT_ID,
1087: NULL, --ORIG_SYSTEM,
1088: NULL, --ORIG_SYSTEM_REFERENCE,
1089: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_CUST_ACCOUNTS',CA.PARTY_ID),
1090: CA.PARTY_ID,
1091: CA.ACCOUNT_NUMBER,
1092: CA.ATTRIBUTE_CATEGORY,
1093: CA.ATTRIBUTE1,

Line 1189: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.CREATED_BY),

1185: CA.LAST_BATCH_ID,
1186: CA.SELLING_PARTY_ID,
1187: CA.PROGRAM_UPDATE_DATE,
1188: CA.CREATED_BY_MODULE,
1189: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.CREATED_BY),
1190: CA.CREATION_DATE,
1191: CA.LAST_UPDATE_DATE,
1192: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.LAST_UPDATED_BY),
1193: CAST(MULTISET (

Line 1192: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.LAST_UPDATED_BY),

1188: CA.CREATED_BY_MODULE,
1189: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.CREATED_BY),
1190: CA.CREATION_DATE,
1191: CA.LAST_UPDATE_DATE,
1192: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CA.LAST_UPDATED_BY),
1193: CAST(MULTISET (
1194: SELECT HZ_ORIG_SYS_REF_OBJ(
1195: NULL, --P_ACTION_TYPE,
1196: ORIG_SYSTEM_REF_ID,

Line 1208: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1204: START_DATE_ACTIVE,
1205: END_DATE_ACTIVE,
1206: PROGRAM_UPDATE_DATE,
1207: CREATED_BY_MODULE,
1208: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1209: CREATION_DATE,
1210: LAST_UPDATE_DATE,
1211: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1212: ATTRIBUTE_CATEGORY,

Line 1211: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

1207: CREATED_BY_MODULE,
1208: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1209: CREATION_DATE,
1210: LAST_UPDATE_DATE,
1211: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
1212: ATTRIBUTE_CATEGORY,
1213: ATTRIBUTE1,
1214: ATTRIBUTE2,
1215: ATTRIBUTE3,

Line 1258: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

1254: INSTRUMENT_TYPE,
1255: ORDER_OF_PREFERENCE,
1256: ASSIGNMENT_START_DATE,
1257: ASSIGNMENT_END_DATE,
1258: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1259: CREATION_DATE,
1260: ASSIGNMENT_LAST_UPDATE,
1261: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1262: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 1261: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

1257: ASSIGNMENT_END_DATE,
1258: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
1259: CREATION_DATE,
1260: ASSIGNMENT_LAST_UPDATE,
1261: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1262: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1263: WHERE CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
1264: CAST( MULTISET ( SELECT HZ_PAYMENT_METHOD_OBJ(
1265: P_ACTION_TYPE,

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

1286: CRM.ATTRIBUTE12,
1287: CRM.ATTRIBUTE13,
1288: CRM.ATTRIBUTE14,
1289: CRM.ATTRIBUTE15,
1290: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
1291: CRM.CREATION_DATE,
1292: CRM.LAST_UPDATE_DATE,
1293: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
1294: FROM RA_CUST_RECEIPT_METHODS CRM

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

1289: CRM.ATTRIBUTE15,
1290: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
1291: CRM.CREATION_DATE,
1292: CRM.LAST_UPDATE_DATE,
1293: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
1294: FROM RA_CUST_RECEIPT_METHODS CRM
1295: WHERE CA.CUST_ACCOUNT_ID = CRM.CUSTOMER_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL )
1296: )
1297: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA