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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26


	SELECT HZ_CUSTOMER_PROFILE_BO(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CUST_ACCOUNT_PROFILE_ID,
		CUST_ACCOUNT_ID,
		STATUS,
		COLLECTOR_ID,
		CREDIT_ANALYST_ID,
		CREDIT_CHECKING,
		NEXT_CREDIT_REVIEW_DATE,
		TOLERANCE,
		DISCOUNT_TERMS,
		DUNNING_LETTERS,
		INTEREST_CHARGES,
		SEND_STATEMENTS,
		CREDIT_BALANCE_STATEMENTS,
		CREDIT_HOLD,
		PROFILE_CLASS_ID,
		SITE_USE_ID,
		CREDIT_RATING,
		RISK_CODE,
		STANDARD_TERMS,
		OVERRIDE_TERMS,
		DUNNING_LETTER_SET_ID,
		INTEREST_PERIOD_DAYS,
		PAYMENT_GRACE_DAYS,
		DISCOUNT_GRACE_DAYS,
		STATEMENT_CYCLE_ID,
		ACCOUNT_STATUS,
		PERCENT_COLLECTABLE,
		AUTOCASH_HIERARCHY_ID,
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		AUTO_REC_INCL_DISPUTED_FLAG,
		TAX_PRINTING_OPTION,
		CHARGE_ON_FINANCE_CHARGE_FLAG,
		GROUPING_RULE_ID,
		CLEARING_DAYS,
		JGZZ_ATTRIBUTE_CATEGORY,
		JGZZ_ATTRIBUTE1,
		JGZZ_ATTRIBUTE2,
		JGZZ_ATTRIBUTE3,
		JGZZ_ATTRIBUTE4,
		JGZZ_ATTRIBUTE5,
		JGZZ_ATTRIBUTE6,
		JGZZ_ATTRIBUTE7,
		JGZZ_ATTRIBUTE8,
		JGZZ_ATTRIBUTE9,
		JGZZ_ATTRIBUTE10,
		JGZZ_ATTRIBUTE11,
		JGZZ_ATTRIBUTE12,
		JGZZ_ATTRIBUTE13,
		JGZZ_ATTRIBUTE14,
		JGZZ_ATTRIBUTE15,
		GLOBAL_ATTRIBUTE1,
		GLOBAL_ATTRIBUTE2,
		GLOBAL_ATTRIBUTE3,
		GLOBAL_ATTRIBUTE4,
		GLOBAL_ATTRIBUTE5,
		GLOBAL_ATTRIBUTE6,
		GLOBAL_ATTRIBUTE7,
		GLOBAL_ATTRIBUTE8,
		GLOBAL_ATTRIBUTE9,
		GLOBAL_ATTRIBUTE10,
		GLOBAL_ATTRIBUTE11,
		GLOBAL_ATTRIBUTE12,
		GLOBAL_ATTRIBUTE13,
		GLOBAL_ATTRIBUTE14,
		GLOBAL_ATTRIBUTE15,
		GLOBAL_ATTRIBUTE16,
		GLOBAL_ATTRIBUTE17,
		GLOBAL_ATTRIBUTE18,
		GLOBAL_ATTRIBUTE19,
		GLOBAL_ATTRIBUTE20,
		GLOBAL_ATTRIBUTE_CATEGORY,
		CONS_INV_FLAG,
		CONS_INV_TYPE,
		AUTOCASH_HIERARCHY_ID_FOR_ADR,
		LOCKBOX_MATCHING_OPTION,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		REVIEW_CYCLE,
		LAST_CREDIT_REVIEW_DATE,
		CREDIT_CLASSIFICATION,
		CONS_BILL_LEVEL,
                LATE_CHARGE_CALCULATION_TRX,
                CREDIT_ITEMS_FLAG,
                DISPUTED_TRANSACTIONS_FLAG,
                LATE_CHARGE_TYPE,
                LATE_CHARGE_TERM_ID,
                INTEREST_CALCULATION_PERIOD,
                HOLD_CHARGED_INVOICES_FLAG,
                MESSAGE_TEXT_ID,
                MULTIPLE_INTEREST_RATES_FLAG,
                CHARGE_BEGIN_DATE,
	CAST(MULTISET (
	SELECT HZ_CUST_PROFILE_AMT_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CUST_ACCT_PROFILE_AMT_ID,
		CUST_ACCOUNT_PROFILE_ID,
		CURRENCY_CODE,
		TRX_CREDIT_LIMIT,
		OVERALL_CREDIT_LIMIT,
		MIN_DUNNING_AMOUNT,
		MIN_DUNNING_INVOICE_AMOUNT,
		MAX_INTEREST_CHARGE,
		MIN_STATEMENT_AMOUNT,
		AUTO_REC_MIN_RECEIPT_AMOUNT,
		INTEREST_RATE,
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		MIN_FC_BALANCE_AMOUNT,
		MIN_FC_INVOICE_AMOUNT,
		CUST_ACCOUNT_ID,
		SITE_USE_ID,
		EXPIRATION_DATE,
		JGZZ_ATTRIBUTE_CATEGORY,
		JGZZ_ATTRIBUTE1,
		JGZZ_ATTRIBUTE2,
		JGZZ_ATTRIBUTE3,
		JGZZ_ATTRIBUTE4,
		JGZZ_ATTRIBUTE5,
		JGZZ_ATTRIBUTE6,
		JGZZ_ATTRIBUTE7,
		JGZZ_ATTRIBUTE8,
		JGZZ_ATTRIBUTE9,
		JGZZ_ATTRIBUTE10,
		JGZZ_ATTRIBUTE11,
		JGZZ_ATTRIBUTE12,
		JGZZ_ATTRIBUTE13,
		JGZZ_ATTRIBUTE14,
		JGZZ_ATTRIBUTE15,
		GLOBAL_ATTRIBUTE1,
		GLOBAL_ATTRIBUTE2,
		GLOBAL_ATTRIBUTE3,
		GLOBAL_ATTRIBUTE4,
		GLOBAL_ATTRIBUTE5,
		GLOBAL_ATTRIBUTE6,
		GLOBAL_ATTRIBUTE7,
		GLOBAL_ATTRIBUTE8,
		GLOBAL_ATTRIBUTE9,
		GLOBAL_ATTRIBUTE10,
		GLOBAL_ATTRIBUTE11,
		GLOBAL_ATTRIBUTE12,
		GLOBAL_ATTRIBUTE13,
		GLOBAL_ATTRIBUTE14,
		GLOBAL_ATTRIBUTE15,
		GLOBAL_ATTRIBUTE16,
		GLOBAL_ATTRIBUTE17,
		GLOBAL_ATTRIBUTE18,
		GLOBAL_ATTRIBUTE19,
		GLOBAL_ATTRIBUTE20,
		GLOBAL_ATTRIBUTE_CATEGORY,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
                EXCHANGE_RATE_TYPE,
                MIN_FC_INVOICE_OVERDUE_TYPE,
                MIN_FC_INVOICE_PERCENT,
                MIN_FC_BALANCE_OVERDUE_TYPE,
                MIN_FC_BALANCE_PERCENT,
                INTEREST_TYPE,
                INTEREST_FIXED_AMOUNT,
                INTEREST_SCHEDULE_ID,
                PENALTY_TYPE,
                PENALTY_RATE,
                MIN_INTEREST_CHARGE,
                PENALTY_FIXED_AMOUNT,
                PENALTY_SCHEDULE_ID )
		FROM HZ_CUST_PROFILE_AMTS
		WHERE SITE_USE_ID = P_SITE_USE_ID) AS HZ_CUST_PROFILE_AMT_OBJ_TBL))
	FROM HZ_CUSTOMER_PROFILES
	WHERE SITE_USE_ID = P_SITE_USE_ID;

Line: 358


	SELECT HZ_CUST_SITE_USE_BO(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CSU.SITE_USE_ID,
		NULL, --CSU.ORIG_SYSTEM,
		NULL, --CSU.ORIG_SYSTEM_REFERENCE,
		CSU.CUST_ACCT_SITE_ID,
		CSU.SITE_USE_CODE,
		CSU.PRIMARY_FLAG,
		CSU.STATUS,
		CSU.LOCATION,
		CSU.BILL_TO_SITE_USE_ID,
		CSU.SIC_CODE,
		CSU.PAYMENT_TERM_ID,
		CSU.GSA_INDICATOR,
		CSU.SHIP_PARTIAL,
		CSU.SHIP_VIA,
		CSU.FOB_POINT,
		CSU.ORDER_TYPE_ID,
		CSU.PRICE_LIST_ID,
		CSU.FREIGHT_TERM,
		CSU.WAREHOUSE_ID,
		CSU.TERRITORY_ID,
		CSU.TAX_REFERENCE,
		CSU.SORT_PRIORITY,
		CSU.TAX_CODE,
		CSU.ATTRIBUTE_CATEGORY,
		CSU.ATTRIBUTE1,
		CSU.ATTRIBUTE2,
		CSU.ATTRIBUTE3,
		CSU.ATTRIBUTE4,
		CSU.ATTRIBUTE5,
		CSU.ATTRIBUTE6,
		CSU.ATTRIBUTE7,
		CSU.ATTRIBUTE8,
		CSU.ATTRIBUTE9,
		CSU.ATTRIBUTE10,
		CSU.ATTRIBUTE11,
		CSU.ATTRIBUTE12,
		CSU.ATTRIBUTE13,
		CSU.ATTRIBUTE14,
		CSU.ATTRIBUTE15,
		CSU.ATTRIBUTE16,
		CSU.ATTRIBUTE17,
		CSU.ATTRIBUTE18,
		CSU.ATTRIBUTE19,
		CSU.ATTRIBUTE20,
		CSU.ATTRIBUTE21,
		CSU.ATTRIBUTE22,
		CSU.ATTRIBUTE23,
		CSU.ATTRIBUTE24,
		CSU.ATTRIBUTE25,
		CSU.DEMAND_CLASS_CODE,
		CSU.TAX_HEADER_LEVEL_FLAG,
		CSU.TAX_ROUNDING_RULE,
		CSU.GLOBAL_ATTRIBUTE1,
		CSU.GLOBAL_ATTRIBUTE2,
		CSU.GLOBAL_ATTRIBUTE3,
		CSU.GLOBAL_ATTRIBUTE4,
		CSU.GLOBAL_ATTRIBUTE5,
		CSU.GLOBAL_ATTRIBUTE6,
		CSU.GLOBAL_ATTRIBUTE7,
		CSU.GLOBAL_ATTRIBUTE8,
		CSU.GLOBAL_ATTRIBUTE9,
		CSU.GLOBAL_ATTRIBUTE10,
		CSU.GLOBAL_ATTRIBUTE11,
		CSU.GLOBAL_ATTRIBUTE12,
		CSU.GLOBAL_ATTRIBUTE13,
		CSU.GLOBAL_ATTRIBUTE14,
		CSU.GLOBAL_ATTRIBUTE15,
		CSU.GLOBAL_ATTRIBUTE16,
		CSU.GLOBAL_ATTRIBUTE17,
		CSU.GLOBAL_ATTRIBUTE18,
		CSU.GLOBAL_ATTRIBUTE19,
		CSU.GLOBAL_ATTRIBUTE20,
		CSU.GLOBAL_ATTRIBUTE_CATEGORY,
		CSU.PRIMARY_SALESREP_ID,
		CSU.FINCHRG_RECEIVABLES_TRX_ID,
		CSU.DATES_NEGATIVE_TOLERANCE,
		CSU.DATES_POSITIVE_TOLERANCE,
		CSU.DATE_TYPE_PREFERENCE,
		CSU.OVER_SHIPMENT_TOLERANCE,
		CSU.UNDER_SHIPMENT_TOLERANCE,
		CSU.ITEM_CROSS_REF_PREF,
		CSU.OVER_RETURN_TOLERANCE,
		CSU.UNDER_RETURN_TOLERANCE,
		CSU.SHIP_SETS_INCLUDE_LINES_FLAG,
		CSU.ARRIVALSETS_INCLUDE_LINES_FLAG,
		CSU.SCHED_DATE_PUSH_FLAG,
		CSU.INVOICE_QUANTITY_RULE,
		CSU.PRICING_EVENT,
		CSU.GL_ID_REC,
		CSU.GL_ID_REV,
		CSU.GL_ID_TAX,
		CSU.GL_ID_FREIGHT,
		CSU.GL_ID_CLEARING,
		CSU.GL_ID_UNBILLED,
		CSU.GL_ID_UNEARNED,
		CSU.GL_ID_UNPAID_REC,
		CSU.GL_ID_REMITTANCE,
		CSU.GL_ID_FACTOR,
		CSU.TAX_CLASSIFICATION,
		CSU.ORG_ID,
		CSU.PROGRAM_UPDATE_DATE,
		CSU.CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.CREATED_BY),
		CSU.CREATION_DATE,
		CSU.LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),
	CAST(MULTISET (
		SELECT HZ_ORIG_SYS_REF_OBJ(
		NULL, --P_ACTION_TYPE,
		ORIG_SYSTEM_REF_ID,
		ORIG_SYSTEM,
		ORIG_SYSTEM_REFERENCE,
		OWNER_TABLE_NAME,
		OWNER_TABLE_ID,
		STATUS,
		REASON_CODE,
		OLD_ORIG_SYSTEM_REFERENCE,
		START_DATE_ACTIVE,
		END_DATE_ACTIVE,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
 		CREATION_DATE,
 		LAST_UPDATE_DATE,
 		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20)
		FROM HZ_ORIG_SYS_REFERENCES OSR
		WHERE OSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
		AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
		AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
		NULL, --HZ_CUSTOMER_PROFILE_BO
	CAST(MULTISET (
	SELECT HZ_BANK_ACCT_USE_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		INSTR_ASSIGNMENT_ID, --BANK_ACCT_USE_ID,
		PAYMENT_FUNCTION,
		PARTY_ID,
		ORG_TYPE,
		ORG_ID,
		CUST_ACCOUNT_ID,
		ACCT_SITE_USE_ID,
		INSTRUMENT_ID,
		INSTRUMENT_TYPE,
		ORDER_OF_PREFERENCE,
		ASSIGNMENT_START_DATE,
	        ASSIGNMENT_END_DATE,
		NULL, --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		NULL, --CREATION_DATE,
		ASSIGNMENT_LAST_UPDATE,
		NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
	FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
	WHERE ACCT_SITE_USE_ID = CSU.SITE_USE_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
	 ( SELECT HZ_PAYMENT_METHOD_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CRM.CUST_RECEIPT_METHOD_ID, --PAYMENT_METHOD_ID,
		CRM.CUSTOMER_ID,
		CRM.RECEIPT_METHOD_ID,
		CRM.PRIMARY_FLAG,
		CRM.SITE_USE_ID,
		CRM.START_DATE,
		CRM.END_DATE,
		CRM.ATTRIBUTE_CATEGORY,
		CRM.ATTRIBUTE1,
		CRM.ATTRIBUTE2,
		CRM.ATTRIBUTE3,
		CRM.ATTRIBUTE4,
		CRM.ATTRIBUTE5,
		CRM.ATTRIBUTE6,
		CRM.ATTRIBUTE7,
		CRM.ATTRIBUTE8,
		CRM.ATTRIBUTE9,
		CRM.ATTRIBUTE10,
		CRM.ATTRIBUTE11,
		CRM.ATTRIBUTE12,
		CRM.ATTRIBUTE13,
		CRM.ATTRIBUTE14,
		CRM.ATTRIBUTE15,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
		CRM.CREATION_DATE,
		CRM.LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
        FROM RA_CUST_RECEIPT_METHODS CRM
        WHERE CSU.SITE_USE_ID = CRM.SITE_USE_ID
        AND ROWNUM = 1)
        )
	FROM HZ_CUST_SITE_USES CSU
	WHERE CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID;

Line: 773


	SELECT HZ_CUST_ACCT_SITE_BO(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CUST_ACCT_SITE_ID,
		NULL, --ORIG_SYSTEM,
		NULL, --ORIG_SYSTEM_REFERENCE,
		CUST_ACCOUNT_ID,
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20,
		GLOBAL_ATTRIBUTE_CATEGORY,
		GLOBAL_ATTRIBUTE1,
		GLOBAL_ATTRIBUTE2,
		GLOBAL_ATTRIBUTE3,
		GLOBAL_ATTRIBUTE4,
		GLOBAL_ATTRIBUTE5,
		GLOBAL_ATTRIBUTE6,
		GLOBAL_ATTRIBUTE7,
		GLOBAL_ATTRIBUTE8,
		GLOBAL_ATTRIBUTE9,
		GLOBAL_ATTRIBUTE10,
		GLOBAL_ATTRIBUTE11,
		GLOBAL_ATTRIBUTE12,
		GLOBAL_ATTRIBUTE13,
		GLOBAL_ATTRIBUTE14,
		GLOBAL_ATTRIBUTE15,
		GLOBAL_ATTRIBUTE16,
		GLOBAL_ATTRIBUTE17,
		GLOBAL_ATTRIBUTE18,
		GLOBAL_ATTRIBUTE19,
		GLOBAL_ATTRIBUTE20,
		STATUS,
		CUSTOMER_CATEGORY_CODE,
		LANGUAGE,
		KEY_ACCOUNT_FLAG,
		TP_HEADER_ID,
		ECE_TP_LOCATION_CODE,
		PRIMARY_SPECIALIST_ID,
		SECONDARY_SPECIALIST_ID,
		TERRITORY_ID,
		TERRITORY,
		TRANSLATED_CUSTOMER_NAME,
		ORG_ID,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		PARTY_SITE_ID,
		NULL, --PARTY_SITE_OS,
		NULL, --PARTY_SITE_OSR,
	CAST(MULTISET (
		SELECT HZ_ORIG_SYS_REF_OBJ(
		NULL, --P_ACTION_TYPE,
		ORIG_SYSTEM_REF_ID,
		ORIG_SYSTEM,
		ORIG_SYSTEM_REFERENCE,
		OWNER_TABLE_NAME,
		OWNER_TABLE_ID,
		STATUS,
		REASON_CODE,
		OLD_ORIG_SYSTEM_REFERENCE,
		START_DATE_ACTIVE,
		END_DATE_ACTIVE,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
 		CREATION_DATE,
 		LAST_UPDATE_DATE,
 		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20)
	FROM HZ_ORIG_SYS_REFERENCES OSR
	WHERE
	OSR.OWNER_TABLE_ID = CAS.CUST_ACCT_SITE_ID
	AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
	AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct site ssm
	CAST(MULTISET (
		SELECT HZ_ORIG_SYS_REF_OBJ(
		NULL, --P_ACTION_TYPE,
		ORIG_SYSTEM_REF_ID,
		ORIG_SYSTEM,
		ORIG_SYSTEM_REFERENCE,
		OWNER_TABLE_NAME,
		OWNER_TABLE_ID,
		STATUS,
		REASON_CODE,
		OLD_ORIG_SYSTEM_REFERENCE,
		START_DATE_ACTIVE,
		END_DATE_ACTIVE,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
 		CREATION_DATE,
 		LAST_UPDATE_DATE,
 		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20)
	FROM HZ_ORIG_SYS_REFERENCES OSR
	WHERE
	OSR.OWNER_TABLE_ID = CAS.PARTY_SITE_ID
	AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
	AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm
		HZ_CUST_SITE_USE_BO_TBL(),
		HZ_CUST_ACCT_CONTACT_BO_TBL())
	FROM HZ_CUST_ACCT_SITES CAS
	WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)
        OR (P_CUST_ACCT_SITE_ID IS NOT NULL
		AND CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID));

Line: 1104


	SELECT HZ_CUST_SITE_USE_V2_BO(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CSU.SITE_USE_ID,
		NULL, --CSU.ORIG_SYSTEM,
		NULL, --CSU.ORIG_SYSTEM_REFERENCE,
		CSU.CUST_ACCT_SITE_ID,
		CSU.SITE_USE_CODE,
		CSU.PRIMARY_FLAG,
		CSU.STATUS,
		CSU.LOCATION,
		CSU.BILL_TO_SITE_USE_ID,
		CSU.SIC_CODE,
		CSU.PAYMENT_TERM_ID,
		CSU.GSA_INDICATOR,
		CSU.SHIP_PARTIAL,
		CSU.SHIP_VIA,
		CSU.FOB_POINT,
		CSU.ORDER_TYPE_ID,
		CSU.PRICE_LIST_ID,
		CSU.FREIGHT_TERM,
		CSU.WAREHOUSE_ID,
		CSU.TERRITORY_ID,
		CSU.TAX_REFERENCE,
		CSU.SORT_PRIORITY,
		CSU.TAX_CODE,
		CSU.ATTRIBUTE_CATEGORY,
		CSU.ATTRIBUTE1,
		CSU.ATTRIBUTE2,
		CSU.ATTRIBUTE3,
		CSU.ATTRIBUTE4,
		CSU.ATTRIBUTE5,
		CSU.ATTRIBUTE6,
		CSU.ATTRIBUTE7,
		CSU.ATTRIBUTE8,
		CSU.ATTRIBUTE9,
		CSU.ATTRIBUTE10,
		CSU.ATTRIBUTE11,
		CSU.ATTRIBUTE12,
		CSU.ATTRIBUTE13,
		CSU.ATTRIBUTE14,
		CSU.ATTRIBUTE15,
		CSU.ATTRIBUTE16,
		CSU.ATTRIBUTE17,
		CSU.ATTRIBUTE18,
		CSU.ATTRIBUTE19,
		CSU.ATTRIBUTE20,
		CSU.ATTRIBUTE21,
		CSU.ATTRIBUTE22,
		CSU.ATTRIBUTE23,
		CSU.ATTRIBUTE24,
		CSU.ATTRIBUTE25,
		CSU.DEMAND_CLASS_CODE,
		CSU.TAX_HEADER_LEVEL_FLAG,
		CSU.TAX_ROUNDING_RULE,
		CSU.GLOBAL_ATTRIBUTE1,
		CSU.GLOBAL_ATTRIBUTE2,
		CSU.GLOBAL_ATTRIBUTE3,
		CSU.GLOBAL_ATTRIBUTE4,
		CSU.GLOBAL_ATTRIBUTE5,
		CSU.GLOBAL_ATTRIBUTE6,
		CSU.GLOBAL_ATTRIBUTE7,
		CSU.GLOBAL_ATTRIBUTE8,
		CSU.GLOBAL_ATTRIBUTE9,
		CSU.GLOBAL_ATTRIBUTE10,
		CSU.GLOBAL_ATTRIBUTE11,
		CSU.GLOBAL_ATTRIBUTE12,
		CSU.GLOBAL_ATTRIBUTE13,
		CSU.GLOBAL_ATTRIBUTE14,
		CSU.GLOBAL_ATTRIBUTE15,
		CSU.GLOBAL_ATTRIBUTE16,
		CSU.GLOBAL_ATTRIBUTE17,
		CSU.GLOBAL_ATTRIBUTE18,
		CSU.GLOBAL_ATTRIBUTE19,
		CSU.GLOBAL_ATTRIBUTE20,
		CSU.GLOBAL_ATTRIBUTE_CATEGORY,
		CSU.PRIMARY_SALESREP_ID,
		CSU.FINCHRG_RECEIVABLES_TRX_ID,
		CSU.DATES_NEGATIVE_TOLERANCE,
		CSU.DATES_POSITIVE_TOLERANCE,
		CSU.DATE_TYPE_PREFERENCE,
		CSU.OVER_SHIPMENT_TOLERANCE,
		CSU.UNDER_SHIPMENT_TOLERANCE,
		CSU.ITEM_CROSS_REF_PREF,
		CSU.OVER_RETURN_TOLERANCE,
		CSU.UNDER_RETURN_TOLERANCE,
		CSU.SHIP_SETS_INCLUDE_LINES_FLAG,
		CSU.ARRIVALSETS_INCLUDE_LINES_FLAG,
		CSU.SCHED_DATE_PUSH_FLAG,
		CSU.INVOICE_QUANTITY_RULE,
		CSU.PRICING_EVENT,
		CSU.GL_ID_REC,
		CSU.GL_ID_REV,
		CSU.GL_ID_TAX,
		CSU.GL_ID_FREIGHT,
		CSU.GL_ID_CLEARING,
		CSU.GL_ID_UNBILLED,
		CSU.GL_ID_UNEARNED,
		CSU.GL_ID_UNPAID_REC,
		CSU.GL_ID_REMITTANCE,
		CSU.GL_ID_FACTOR,
		CSU.TAX_CLASSIFICATION,
		CSU.ORG_ID,
		CSU.PROGRAM_UPDATE_DATE,
		CSU.CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.CREATED_BY),
		CSU.CREATION_DATE,
		CSU.LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),
	CAST(MULTISET (
		SELECT HZ_ORIG_SYS_REF_OBJ(
		NULL, --P_ACTION_TYPE,
		ORIG_SYSTEM_REF_ID,
		ORIG_SYSTEM,
		ORIG_SYSTEM_REFERENCE,
		OWNER_TABLE_NAME,
		OWNER_TABLE_ID,
		STATUS,
		REASON_CODE,
		OLD_ORIG_SYSTEM_REFERENCE,
		START_DATE_ACTIVE,
		END_DATE_ACTIVE,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
 		CREATION_DATE,
 		LAST_UPDATE_DATE,
 		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20)
		FROM HZ_ORIG_SYS_REFERENCES OSR
		WHERE OSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
		AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
		AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
		NULL, --HZ_CUSTOMER_PROFILE_BO
	CAST(MULTISET (
	SELECT HZ_BANK_ACCT_USE_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		INSTR_ASSIGNMENT_ID, --BANK_ACCT_USE_ID,
		PAYMENT_FUNCTION,
		PARTY_ID,
		ORG_TYPE,
		ORG_ID,
		CUST_ACCOUNT_ID,
		ACCT_SITE_USE_ID,
		INSTRUMENT_ID,
		INSTRUMENT_TYPE,
		ORDER_OF_PREFERENCE,
		ASSIGNMENT_START_DATE,
		ASSIGNMENT_END_DATE,
		NULL, --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		NULL, --CREATION_DATE,
		ASSIGNMENT_LAST_UPDATE,
		NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
	FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
	WHERE ACCT_SITE_USE_ID = CSU.SITE_USE_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
        CAST( MULTISET (
	SELECT HZ_PAYMENT_METHOD_OBJ(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CRM.CUST_RECEIPT_METHOD_ID, --PAYMENT_METHOD_ID,
		CRM.CUSTOMER_ID,
		CRM.RECEIPT_METHOD_ID,
		CRM.PRIMARY_FLAG,
		CRM.SITE_USE_ID,
		CRM.START_DATE,
		CRM.END_DATE,
		CRM.ATTRIBUTE_CATEGORY,
		CRM.ATTRIBUTE1,
		CRM.ATTRIBUTE2,
		CRM.ATTRIBUTE3,
		CRM.ATTRIBUTE4,
		CRM.ATTRIBUTE5,
		CRM.ATTRIBUTE6,
		CRM.ATTRIBUTE7,
		CRM.ATTRIBUTE8,
		CRM.ATTRIBUTE9,
		CRM.ATTRIBUTE10,
		CRM.ATTRIBUTE11,
		CRM.ATTRIBUTE12,
		CRM.ATTRIBUTE13,
		CRM.ATTRIBUTE14,
		CRM.ATTRIBUTE15,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.CREATED_BY),
		CRM.CREATION_DATE,
		CRM.LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
        FROM RA_CUST_RECEIPT_METHODS CRM
        WHERE CSU.SITE_USE_ID = CRM.SITE_USE_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL)
         )
	FROM HZ_CUST_SITE_USES CSU
	WHERE CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID;

Line: 1519


	SELECT HZ_CUST_ACCT_SITE_V2_BO(
		P_ACTION_TYPE,
                NULL, -- COMMON_OBJ_ID
		CUST_ACCT_SITE_ID,
		NULL, --ORIG_SYSTEM,
		NULL, --ORIG_SYSTEM_REFERENCE,
		CUST_ACCOUNT_ID,
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20,
		GLOBAL_ATTRIBUTE_CATEGORY,
		GLOBAL_ATTRIBUTE1,
		GLOBAL_ATTRIBUTE2,
		GLOBAL_ATTRIBUTE3,
		GLOBAL_ATTRIBUTE4,
		GLOBAL_ATTRIBUTE5,
		GLOBAL_ATTRIBUTE6,
		GLOBAL_ATTRIBUTE7,
		GLOBAL_ATTRIBUTE8,
		GLOBAL_ATTRIBUTE9,
		GLOBAL_ATTRIBUTE10,
		GLOBAL_ATTRIBUTE11,
		GLOBAL_ATTRIBUTE12,
		GLOBAL_ATTRIBUTE13,
		GLOBAL_ATTRIBUTE14,
		GLOBAL_ATTRIBUTE15,
		GLOBAL_ATTRIBUTE16,
		GLOBAL_ATTRIBUTE17,
		GLOBAL_ATTRIBUTE18,
		GLOBAL_ATTRIBUTE19,
		GLOBAL_ATTRIBUTE20,
		STATUS,
		CUSTOMER_CATEGORY_CODE,
		LANGUAGE,
		KEY_ACCOUNT_FLAG,
		TP_HEADER_ID,
		ECE_TP_LOCATION_CODE,
		PRIMARY_SPECIALIST_ID,
		SECONDARY_SPECIALIST_ID,
		TERRITORY_ID,
		TERRITORY,
		TRANSLATED_CUSTOMER_NAME,
		ORG_ID,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
		CREATION_DATE,
		LAST_UPDATE_DATE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		PARTY_SITE_ID,
		NULL, --PARTY_SITE_OS,
		NULL, --PARTY_SITE_OSR,
	CAST(MULTISET (
		SELECT HZ_ORIG_SYS_REF_OBJ(
		NULL, --P_ACTION_TYPE,
		ORIG_SYSTEM_REF_ID,
		ORIG_SYSTEM,
		ORIG_SYSTEM_REFERENCE,
		OWNER_TABLE_NAME,
		OWNER_TABLE_ID,
		STATUS,
		REASON_CODE,
		OLD_ORIG_SYSTEM_REFERENCE,
		START_DATE_ACTIVE,
		END_DATE_ACTIVE,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
 		CREATION_DATE,
 		LAST_UPDATE_DATE,
 		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20)
	FROM HZ_ORIG_SYS_REFERENCES OSR
	WHERE
	OSR.OWNER_TABLE_ID = CAS.CUST_ACCT_SITE_ID
	AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
	AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct site ssm
	CAST(MULTISET (
		SELECT HZ_ORIG_SYS_REF_OBJ(
		NULL, --P_ACTION_TYPE,
		ORIG_SYSTEM_REF_ID,
		ORIG_SYSTEM,
		ORIG_SYSTEM_REFERENCE,
		OWNER_TABLE_NAME,
		OWNER_TABLE_ID,
		STATUS,
		REASON_CODE,
		OLD_ORIG_SYSTEM_REFERENCE,
		START_DATE_ACTIVE,
		END_DATE_ACTIVE,
		PROGRAM_UPDATE_DATE,
		CREATED_BY_MODULE,
		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
 		CREATION_DATE,
 		LAST_UPDATE_DATE,
 		HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		ATTRIBUTE16,
		ATTRIBUTE17,
		ATTRIBUTE18,
		ATTRIBUTE19,
		ATTRIBUTE20)
	FROM HZ_ORIG_SYS_REFERENCES OSR
	WHERE
	OSR.OWNER_TABLE_ID = CAS.PARTY_SITE_ID
	AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
	AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm
		HZ_CUST_SITE_USE_V2_BO_TBL(),
		HZ_CUST_ACCT_CONTACT_BO_TBL())
	FROM HZ_CUST_ACCT_SITES CAS
	WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)
        OR (P_CUST_ACCT_SITE_ID IS NOT NULL
		AND CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID));