Search Results rct_class_global_attr_cat




Overview
Explore in AI Chat

Overview

APPS.AR_RCT_METHOD_S_V is a Receivables (AR) reporting and integration view that joins receipt classes, receipt methods, and Oracle Subledger Accounting (XLA) extract lines. It is defined with a "S" suffix, indicating it is a seed or supplied view used for extracts tied to the credit memo event class. The view presents a flattened, denormalized combination of receipt-class attributes and receipt-method attributes, aligned to XLA line data for credit memo events. In Oracle EBS 12.1.1 and 12.2.2, this view is primarily referenced by Subledger Accounting extraction programs and downstream reporting that need receipt classification and receipt method context for credit memo accounting events. The presence of the column alias RCT_MTHD_PAYMENT_TYPE_CODE, mapped from AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE, is significant because it is the identifier users search for when investigating payment channel codes in receipt method contexts.

Underlying Base Objects

The view is defined over three objects, all accessed through APPS synonyms:

  • AR_RECEIPT_CLASSES (aliased rc1) — Provides receipt class attributes such as clear flag, confirm flag, creation method, creation status, remit flag, and remit method.
  • AR_RECEIPT_METHODS (aliased rm1) — Provides receipt method attributes including name, printed name, payment channel, and the receipt class foreign key.
  • AR_XLA_LINES_EXTRACT (aliased l) — Provides the XLA line context, including event identifier, line number, language, and ledger identifier.

Joins are established on RM1.RECEIPT_METHOD_ID = L.RECEIPT_METHOD_ID and RM1.RECEIPT_CLASS_ID = RC1.RECEIPT_CLASS_ID. The view filters on L.LEVEL_FLAG = 'H' and L.EVENT_CLASS_CODE = 'CREDIT_MEMO', restricting rows to header-level credit memo event records.

Key Columns

Common Use Cases and Queries

This view is typically queried to reconcile receipt method payment channels against credit memo XLA extraction rows, or to validate receipt class configuration in the context of a specific ledger and accounting event.

  • Verify the payment channel code for receipt methods used in credit memo events.
  • Audit receipt class flags (clear, confirm, remit) for accounting extract completeness.
  • Report credit memo XLA lines grouped by ledger and receipt method.
SELECT rct_mthd_name,
       rct_mthd_payment_type_code,
       rct_class_name,
       ledger_id,
       COUNT(*) line_count
FROM   apps.ar_rct_method_s_v
WHERE  rct_mthd_payment_type_code = :payment_type
GROUP  BY rct_mthd_name,
          rct_mthd_payment_type_code,
          rct_class_name,
          ledger_id;

SELECT event_id,
       line_number,
       rct_mthd_name,
       rct_mthd_payment_type_code,
       rct_class_remit_flag,
       rct_class_confirm_flag
FROM   apps.ar_rct_method_s_v
WHERE  event_id = :event_id
ORDER  BY line_number;

Because the view is supplied for XLA credit memo extraction, queries should account for the fixed LEVEL_FLAG = 'H' and EVENT_CLASS_CODE = 'CREDIT_MEMO' filters already embedded in the view text.