Results for “merchant_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.AR_RECEIPT_METHOD_NAME_V view is a Receivables (AR) reporting and integration object that exposes a filtered, denormalized list of receipt methods restricted to credit card payment processing. Its defining characteristic is the predicate RM.PAYMENT_TYPE_CODE = 'CREDIT_CARD' combined with a date-effectiveness filter, which together ensure that only currently active credit card receipt methods are returned. Because the view projects the MERCHANT_ID attribute alongside the receipt method identifier, name, and class, it serves as the canonical lookup for mapping a receipt method to its associated merchant identifier when processing credit card transactions. It is commonly consumed by payment integration code, refund workflows, and reconciliation reports that must determine which merchant account is tied to a given receipt method.
Underlying Base Objects
The view is defined in the APPS schema and is constructed over two base objects, both referenced through synonyms:
- AR_RECEIPT_METHODS (SYNONYM) — aliased as
RMin the view text; the primary source of receipt method identity, name, merchant identifier, payment type, and effective dating. - AR_RECEIPT_CLASSES (SYNONYM) — aliased as
RC; joined onRM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_IDto supply the human-readable receipt class name.
The join is an inner equi-join on the receipt class identifier. The view applies two filtering conditions: the payment type must equal CREDIT_CARD, and the current system date (truncated) must fall between RM.START_DATE and NVL(RM.END_DATE, TRUNC(SYSDATE)), meaning records without an end date are treated as open-ended and therefore active.
Key Columns
- RECEIPT_METHOD_ID — Primary identifier of the receipt method from AR_RECEIPT_METHODS; the key used to join back to transactional tables such as AR_CASH_RECEIPTS.
- NAME — The receipt method name (
RM.NAME), the descriptive label presented to users and used in reports. - MERCHANT_ID — The merchant identifier (
RM.MERCHANT_ID) associated with the credit card receipt method. This is the attribute most frequently searched for in integration and settlement contexts, as it links the EBS receipt method to the external payment processor's merchant account. - CLASS — The receipt class name (
RC.NAME), projected under the aliasCLASS, indicating the classification of the receipt method.
Common Use Cases and Queries
Typical scenarios include resolving a merchant identifier for a credit card receipt method during payment authorization, validating that a receipt method is currently effective before use, and populating LOV-style lookup queries in integrations. A representative query listing all active credit card methods with their merchants is:
SELECT receipt_method_id, name, merchant_id, class FROM apps.ar_receipt_method_name_v;- Filtering by a specific merchant:
SELECT receipt_method_id, name, class FROM apps.ar_receipt_method_name_v WHERE merchant_id = :merchant_id; - Joining to transactions to attribute receipts:
SELECT v.name, v.merchant_id, r.amount FROM apps.ar_receipt_method_name_v v, apps.ar_cash_receipts r WHERE v.receipt_method_id = r.receipt_method_id;
Because the view already enforces payment type and date effectiveness, consumers do not need to reapply those predicates, which reduces the risk of inconsistent filtering across integrations.
-
APPS.AR_RECEIPT_METHOD_NAME_V·↳ AR_RECEIPT_CLASSES·↳ AR_RECEIPT_METHODS·Explore AR module →
-
APPS.AR_RECEIPT_METHOD_NAME_V·↳ AR_RECEIPT_CLASSES·↳ AR_RECEIPT_METHODS·Explore AR module →
-
gives information regarding receipt methods available in AR
APPS.ASO_I_RECEIPT_METHODS_V·↳ AR_RECEIPT_METHODS·Explore ASO module →
-
gives information regarding receipt methods available in AR
APPS.ASO_I_RECEIPT_METHODS_V·↳ AR_RECEIPT_METHODS·Explore ASO module →
-
View: IBY_TRANSACTIONS_V 12.2.2
APPS.IBY_TRANSACTIONS_V·↳ IBY_TRXN_CORE·↳ IBY_TRXN_SUMMARIES_ALL·Explore IBY module →
-
View: IGS_FI_INV_INT 12.1.1
APPS.IGS_FI_INV_INT·↳ IGS_FI_INV_INT_ALL·Explore IGS module →
-
View: IBY_TRANSACTIONS_SET_V 12.1.1
APPS.IBY_TRANSACTIONS_SET_V·↳ IBY_TRXN_EXTENDED·↳ IBY_TRXN_SUMMARIES_ALL·Explore IBY module →
-
View: IBY_TRANSACTIONS_V 12.1.1
APPS.IBY_TRANSACTIONS_V·↳ IBY_TRXN_CORE·↳ IBY_TRXN_SUMMARIES_ALL·Explore IBY module →
-
View: IGS_FI_CREDITS 12.1.1
This view is a multi-org filter flat view based on table IGS_FI_CREDITS_ALL.
APPS.IGS_FI_CREDITS·↳ IGS_FI_CREDITS_ALL·Explore IGS module →
-
No longer used.
-
View: IBY_TRANSACTIONS_SET_V 12.2.2
APPS.IBY_TRANSACTIONS_SET_V·↳ IBY_TRXN_EXTENDED·↳ IBY_TRXN_SUMMARIES_ALL·Explore IBY module →
-
View: IGS_FI_CRD_INT 12.1.1
No longer used.
APPS.IGS_FI_CRD_INT·↳ IGS_FI_CRD_INT_ALL·Explore IGS module →
-
Information about payment methods
-
View: IGS_FI_CREDITS_V 12.1.1
This is a multi-org view based on org filtered view IGS_FI_CREDITS and join with view IGS_LOOKUPS_VIEW and IGS_FI_CR_TYPES view to resolve Lookup Meaning and Credit Type Names from IDs
APPS.IGS_FI_CREDITS_V·↳ IGF_LOOKUPS_VIEW·↳ IGS_CA_INST·↳ IGS_EN_GEN_003·Explore IGS module →
-
This table contains information about all credit or payment transactions and is the central repository for all credits and payments related information in Student Finance.
-
Information about payment methods
-
This interface table stores invoice data generated by invoice process.
-
View: IGS_FI_INV_IGF_V 12.1.1
This view is used to fetch all the charges from the view igs_fi_inv_int. A link with igs_fi_fee_type is also made to fetch the fee class defined for the fee type.This view has been primarily created for Financial Aid Disbursement to access
APPS.IGS_FI_INV_IGF_V·↳ IGS_FI_FEE_TYPE·↳ IGS_FI_INV_INT·Explore IGS module →
-
View: IGS_FI_INV_INT_V 12.1.1
This view is created by joining view IGS_FI_INV_INT and IGS_LOOKUPS_VIEW to resolve meaning of lookup codes.
APPS.IGS_FI_INV_INT_V·↳ IGS_FI_INV_INT·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
View: IGS_FI_OTC_CHARGES_V 12.1.1
The view contains information on the charges(of type external) that are created at the time of receipt creation.
APPS.IGS_FI_OTC_CHARGES_V·↳ IGS_FI_ACC·↳ IGS_FI_INVLN_INT·↳ IGS_FI_INV_INT·Explore IGS module →
-
VIEW: AR.AR_RECEIPT_METHODS# 12.2.2
-
View: IGS_FI_CRD_INT 12.2.2
No longer used.
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_CREDITS 12.2.2
This view is a multi-org filter flat view based on table IGS_FI_CREDITS_ALL.
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_INV_INT 12.2.2
Not implemented in this database·Explore IGS module →
-
VIEW: AR.AR_RECEIPT_METHODS# 12.2.2
-
VIEW: APPS.IGS_FI_CRD_INT 12.1.1