View: AR_INTEREST_HEADERS_V

Product:	AR - Receivables
Description:	Late Charge header preview work bench
Implementation/DBA Data:	APPS.AR_INTEREST_HEADERS_V

View Text

SELECT H.INTEREST_HEADER_ID
, H.INTEREST_BATCH_ID
, H.CUSTOMER_ID
, H.CUSTOMER_SITE_USE_ID
, H.CURRENCY_CODE
, H.EXCHANGE_RATE_TYPE
, CT.USER_CONVERSION_TYPE EXCHANGE_RATE_TYPE_DSP
, H.EXCHANGE_RATE
, PARTY.PARTY_NAME
, C.ACCOUNT_NUMBER
, SU.LOCATION
, H.ORG_ID
, ARP_ADDR_PKG.FORMAT_ADDRESS ( ADDR.ADDRESS_STYLE
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.COUNTY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME) CONCATENATED_ADDRESS
, H.COLLECTOR_ID
, H.CUSTOMER_PROFILE_ID
, AR_INTEREST_HEADERS_PKG.GET_HEADER_AMOUNT(H.INTEREST_HEADER_ID) HEADER_AMOUNT
, H.HEADER_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_LATE_CHARGE_TYPE'
, H.HEADER_TYPE) HEADER_TYPE_M
, H.LATE_CHARGE_CALCULATION_TRX
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('AR_MANDATORY_LATE_CHARGES'
, H.LATE_CHARGE_CALCULATION_TRX) LATE_CHARGE_CALCULATION_TRX_M
, H.CREDIT_ITEMS_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, H.CREDIT_ITEMS_FLAG) CREDIT_ITEMS_FLAG_M
, H.DISPUTED_TRANSACTIONS_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, H.DISPUTED_TRANSACTIONS_FLAG) DISPUTED_TRANSACTIONS_FLAG_M
, H.PAYMENT_GRACE_DAYS
, H.LATE_CHARGE_TERM_ID
, RT.NAME LATE_CHARGE_TERM_NAME
, H.INTEREST_PERIOD_DAYS
, H.INTEREST_CALCULATION_PERIOD
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_CALCULATION_PERIOD'
, H.INTEREST_CALCULATION_PERIOD) INTEREST_CALCULATION_PERIOD_M
, H.CHARGE_ON_FINANCE_CHARGE_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, H.CHARGE_ON_FINANCE_CHARGE_FLAG) FORMULA_M
, H.HOLD_CHARGED_INVOICES_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, H.HOLD_CHARGED_INVOICES_FLAG) HOLD_CHARGED_INVOICES_FLAG_M
, H.MESSAGE_TEXT_ID
, MSG.NAME MESSAGE_TEXT_NAME
, H.MULTIPLE_INTEREST_RATES_FLAG
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('YES/NO'
, H.MULTIPLE_INTEREST_RATES_FLAG) MULTIPLE_INTEREST_RATES_FLAG_M
, H.CHARGE_BEGIN_DATE
, H.CUST_ACCT_PROFILE_AMT_ID
, H.MIN_FC_INVOICE_OVERDUE_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_AMOUNT_PERCENT'
, H.MIN_FC_INVOICE_OVERDUE_TYPE) MIN_FC_INVOICE_OVERDUE_TYPE_M
, H.MIN_FC_INVOICE_AMOUNT
, H.MIN_FC_INVOICE_PERCENT
, DECODE(H.MIN_FC_INVOICE_OVERDUE_TYPE
, 'AMOUNT'
, H.MIN_FC_INVOICE_AMOUNT
, H.MIN_FC_INVOICE_PERCENT) MIN_FC_INVOICE_VALUE
, H.MIN_FC_BALANCE_OVERDUE_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_AMOUNT_PERCENT'
, H.MIN_FC_BALANCE_OVERDUE_TYPE) MIN_FC_BALANCE_OVERDUE_TYPE_M
, H.MIN_FC_BALANCE_AMOUNT
, H.MIN_FC_BALANCE_PERCENT
, DECODE(H.MIN_FC_BALANCE_OVERDUE_TYPE
, 'AMOUNT'
, H.MIN_FC_BALANCE_AMOUNT
, H.MIN_FC_BALANCE_PERCENT) MIN_FC_BALANCE_VALUE
, H.MIN_INTEREST_CHARGE
, H.MAX_INTEREST_CHARGE
, H.INTEREST_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_INTEREST_PENALTY_TYPE'
, H.INTEREST_TYPE) INTEREST_TYPE_M
, H.INTEREST_RATE
, H.INTEREST_FIXED_AMOUNT
, H.INTEREST_SCHEDULE_ID
, INTSCH.SCHEDULE_NAME INTEREST_SCHEDULE_NAME
, DECODE(H.INTEREST_TYPE
, 'FIXED_AMOUNT'
, H.INTEREST_FIXED_AMOUNT
, 'FIXED_RATE'
, H.INTEREST_RATE
, H.INTEREST_SCHEDULE_ID) INTEREST_TYPE_VALUE
, H.PENALTY_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_INTEREST_PENALTY_TYPE'
, H.PENALTY_TYPE) PENALTY_TYPE_M
, H.PENALTY_RATE
, H.PENALTY_FIXED_AMOUNT
, H.PENALTY_SCHEDULE_ID
, PENSCH.SCHEDULE_NAME PENALTY_SCHEDULE_NAME
, DECODE(H.PENALTY_TYPE
, 'FIXED_AMOUNT'
, H.PENALTY_FIXED_AMOUNT
, 'FIXED_RATE'
, H.PENALTY_RATE
, H.INTEREST_SCHEDULE_ID) PENALTY_TYPE_VALUE
, H.LAST_ACCRUE_CHARGE_DATE
, H.LEGAL_ENTITY_ID
, XLEP.LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, H.PROCESS_MESSAGE
, H.PROCESS_STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_PROCESS_STATUS'
, H.PROCESS_STATUS) PROCESS_STATUS_M
, H.CUST_TRX_TYPE_ID
, TTY.NAME TRX_NAME
, H.OBJECT_VERSION_NUMBER
, H.LAST_UPDATED_BY
, H.LAST_UPDATE_DATE
, H.LAST_UPDATE_LOGIN
, H.CREATED_BY
, H.CREATION_DATE
, H.DISPLAY_FLAG
FROM AR_INTEREST_HEADERS H
, HZ_CUST_ACCOUNTS C
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES SU
, HZ_CUST_ACCT_SITES SITE
, HZ_PARTY_SITES PS
, HZ_LOCATIONS ADDR
, FND_TERRITORIES_VL TERR
, GL_DAILY_CONVERSION_TYPES CT
, RA_TERMS RT
, AR_STANDARD_TEXT MSG
, AR_CHARGE_SCHEDULES INTSCH
, AR_CHARGE_SCHEDULES PENSCH
, RA_CUST_TRX_TYPES TTY
, (SELECT X.LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, X.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, SYSP.ORG_ID ORG_ID
FROM XLE_LE_OU_LEDGER_V X
, AR_SYSTEM_PARAMETERS SYSP
WHERE SYSP.ORG_ID = X.OPERATING_UNIT_ID
AND SYSP.SET_OF_BOOKS_ID = X.LEDGER_ID) XLEP
WHERE H.CUSTOMER_ID = C.CUST_ACCOUNT_ID
AND H.CUSTOMER_SITE_USE_ID = SU.SITE_USE_ID
AND SU.CUST_ACCT_SITE_ID = SITE.CUST_ACCT_SITE_ID
AND SITE.PARTY_SITE_ID = PS.PARTY_SITE_ID
AND PARTY.PARTY_ID =C.PARTY_ID(+)
AND PS.LOCATION_ID = ADDR.LOCATION_ID
AND ADDR.COUNTRY = TERR.TERRITORY_CODE
AND CT.CONVERSION_TYPE(+) = H.EXCHANGE_RATE_TYPE
AND H.LATE_CHARGE_TERM_ID = RT.TERM_ID(+)
AND H.MESSAGE_TEXT_ID = MSG.STANDARD_TEXT_ID(+)
AND H.INTEREST_SCHEDULE_ID = INTSCH.SCHEDULE_ID(+)
AND H.PENALTY_SCHEDULE_ID = PENSCH.SCHEDULE_ID(+)
AND H.CUST_TRX_TYPE_ID = TTY.CUST_TRX_TYPE_ID(+)
AND H.LEGAL_ENTITY_ID = XLEP.LEGAL_ENTITY_ID(+)
AND H.ORG_ID = XLEP.ORG_ID(+)

Columns