Search Results paycredit_card_code

Overview

The view IBE_ORDER_QUOTE_PAY_TAX_V belongs to the IBE – iStore product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated, denormalized projection of iStore quote payment and tax information, joining payment records captured against a quote header or quote line with the associated tax detail rows. The view is intended primarily for reporting, integration, and inquiry purposes rather than as a transactional base object; the ETRM metadata explicitly records it as "Not implemented in this database," meaning it is not instantiated as a standalone database object in the documented environment and should be treated as a documentation-level or reference-level artifact.

In the context of the user search term "orig_tax_code", this view is relevant because the tax segment of the projection (sourced from the TAX alias) is where origin tax codes and related tax determination attributes would be surfaced. Note that the documented excerpt of the view text does not explicitly expose an ORIG_TAX_CODE column; the column list truncates at the TAX attributes and does not show an ORIG_TAX_CODE or equivalent alias. Users searching for orig_tax_code should therefore verify the actual view definition in their instance's data dictionary (`DBA_VIEWS`, `ALL_VIEWS`, or `DBA_TAB_COLUMNS`) before relying on this view as the source of that attribute.

Underlying Base Objects

The ETRM metadata records no documented base objects for this view, and lists the owner as blank. However, the embedded view text reveals the two driving aliases used in the join:

• PAY – the payment source, contributing the payment identifier, quote header and line identifiers, payment type code, payment reference number, payment option, payment term, credit card attributes, and payment amounts, plus the standard WHO columns and the ATTRIBUTE1–15 flexfield columns.
• TAX – the tax source, contributing the tax detail identifier and its associated WHO and program columns, followed by the tax attributes that would include the origin tax code where defined.

Because the metadata does not name the physical tables, the payment and tax rows are understood to originate from the iStore quote payment and quote tax detail tables respectively. In 12.1.1 and 12.2.2 these are typically the payment and tax detail entities linked by QUOTE_HEADER_ID and QUOTE_LINE_ID. The view joins these two sources so that each payment row is presented alongside its corresponding tax detail.

Key Columns

• PAYPAYMENT_ID – unique identifier of the payment record; the primary correlation key for the PAY source.
• PAYQUOTE_HEADER_ID / PAYQUOTE_LINE_ID – the quote header and quote line to which the payment applies; these are the join keys connecting the view back to iStore quote tables.
• PAYPAYMENT_TYPE_CODE, PAYPAYMENT_OPTION, PAYPAYMENT_TERM_ID – classify the payment method, option, and terms.
• PAYCREDIT_CARD_CODE, PAYCREDIT_CARD_HOLDER_NAME, PAYCREDIT_CARD_EXPIRATION_DATE, PAYCREDIT_CARD_APPROVAL_CODE, PAYCREDIT_CARD_APPROVAL_DATE – credit card authorization and settlement attributes.
• PAYPAYMENT_AMOUNT – the monetary value tendered against the quote.
• PAYATTRIBUTE_CATEGORY and PAYATTRIBUTE1–15 – descriptive flexfield storage on the payment record.
• TAXTAX_DETAIL_ID – unique identifier of the tax detail row; the primary correlation key for the TAX source.
• TAXCREATION_DATE, TAXLAST_UPDATE_DATE, TAXLAST_UPDATED_BY, TAXREQUEST_ID, TAXPROGRAM_APPLICATION_ID, TAXPROGRAM_ID, TAXPROGRAM_UPDATE_DATE – audit and concurrent program context for the tax row.

The tax attributes that follow in the truncated view text are where origin tax code and related tax determination fields (such as tax rate, jurisdiction, and tax regime) would appear. Since the excerpt does not expose ORIG_TAX_CODE explicitly, confirm the actual column presence in your environment.

Common Use Cases and Queries

The view supports reconciliation of iStore quote payments against their tax details, and is useful for extract-style reporting and integration payloads. A typical query joins payments and tax by quote identifier:

• Reconcile payment amounts collected against tax detail per quote line.
• Extract credit card authorization and approval data for settlement reporting.
• Surface tax determination attributes, including origin tax code where present.
• Feed external tax or financial systems with quote payment and tax rows.

Sample query:

• SELECT v.PAYQUOTE_HEADER_ID, v.PAYQUOTE_LINE_ID, v.PAYPAYMENT_ID, v.PAYPAYMENT_TYPE_CODE, v.PAYPAYMENT_AMOUNT, v.TAXTAX_DETAIL_ID FROM IBE_ORDER_QUOTE_PAY_TAX_V v WHERE v.PAYQUOTE_HEADER_ID = :p_quote_header_id;

Before using this view for orig_tax_code, validate its column list against DBA_TAB_COLUMNS, because the documented definition is incomplete and the object is marked as not implemented in the reference database.