The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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));
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;
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));