Results for “ar_gta_trx_lines_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_GTA_TRX_LINES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It resides in the Oracle Receivables (AR) product family and exposes line-level detail for GTA (Goods and Services Tax / Global Tax Administration) invoices and VAT invoices. The view is documented in the ETRM repository with a status of VALID and is intended to provide reporting and integration access to the transaction line information stored in the Receivables GTA transaction tables.

The view presents a flattened, denormalized representation of GTA invoice lines, including item identification, tax treatment, quantity, pricing, amount, currency conversion, discount handling, and the standard Oracle EBS who-columns and descriptive flexfield (DFF) attributes. Because the view is defined with a simple projection over a single base object, it inherits the transactional columns of the underlying table without additional joins or aggregation, making it suitable for direct query in reports, extracts, and downstream integrations.

Underlying Base Objects

The view is defined over a single base object: AR_GTA_TRX_LINES_ALL, which is exposed in the APPS schema as a synonym. The data dictionary defines the view with a SELECT statement that projects the ROWID and the full set of line attributes from that table. The referenced column list includes ORG_ID, GTA_TRX_HEADER_ID, GTA_TRX_LINE_ID, LINE_NUMBER, ITEM_NUMBER, ITEM_DESCRIPTION, ITEM_MODEL, ITEM_TAX_DENOMINATION, TAX_RATE, UOM, QUANTITY, UNIT_PRICE, AMOUNT, ORIGINAL_CURRENCY_AMOUNT, ENABLED_FLAG, the audit columns, the concurrent program request columns, ATTRIBUTE_CATEGORY through ATTRIBUTE15, and the discount columns DISCOUNT_AMOUNT, DISCOUNT_TAX_AMOUNT, and DISCOUNT_RATE.

Because the view is a direct projection of AR_GTA_TRX_LINES_ALL, it carries no independent storage and no filtering predicate beyond what is defined in the view text. All row-level security, operating unit filtering, and enabled-flag handling must be applied by the consuming report or integration. The GTA_TRX_HEADER_ID column provides the link back to the corresponding GTA invoice header, allowing header and line data to be correlated in reporting queries.

Key Columns

• GTA_TRX_HEADER_ID — Foreign key to the GTA transaction header; used to join line detail to header-level invoice information.
• GTA_TRX_LINE_ID — Unique identifier for the GTA transaction line.
• LINE_NUMBER — Sequence number of the line within the invoice.
• ITEM_NUMBER, ITEM_DESCRIPTION, ITEM_MODEL — Item identification and descriptive attributes for the line.
• ITEM_TAX_DENOMINATION, TAX_RATE — Tax classification and rate applied to the line.
• UOM, QUANTITY, UNIT_PRICE, AMOUNT — Quantity, unit price, and extended line amount.
• ORIGINAL_CURRENCY_AMOUNT — The line amount expressed in the original (transaction) currency; this is the column most relevant to currency-aware reporting and reconciliation, since it preserves the entered amount prior to any functional-currency conversion.
• ENABLED_FLAG — Indicates whether the line is active; used to exclude inactive or voided lines from reporting output.
• DISCOUNT_AMOUNT, DISCOUNT_TAX_AMOUNT, DISCOUNT_RATE — Discount values and the associated tax on discount, supporting net-of-discount calculations.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — Descriptive flexfield segments available for client-specific extensions.
• ORG_ID — Operating unit identifier, essential for multi-org filtering.
• Audit and request columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE for lineage and concurrency tracking.

Common Use Cases and Queries

The view is typically queried to extract GTA and VAT invoice line detail for tax reporting, reconciliation, and interface feeds. A frequent requirement is to report line amounts in original currency while filtering to active lines within a specific operating unit, as illustrated below.

• VAT invoice line reporting by operating unit.
• Reconciliation of original-currency amounts against functional-currency amounts.
• Extracts feeding external tax filing or audit systems.
• Joining line detail to header information for complete invoice views.

Sample query returning active lines with original currency amounts:

SELECT GTA_TRX_HEADER_ID, GTA_TRX_LINE_ID, LINE_NUMBER, ITEM_NUMBER, TAX_RATE, QUANTITY, UNIT_PRICE, AMOUNT, ORIGINAL_CURRENCY_AMOUNT, DISCOUNT_AMOUNT FROM AR_GTA_TRX_LINES_V WHERE ORG_ID = :p_org_id AND ENABLED_FLAG = 'Y' ORDER BY GTA_TRX_HEADER_ID, LINE_NUMBER;

Because the view performs no joins, consumers requiring header attributes such as invoice number or currency code must join to the corresponding GTA transaction header object on GTA_TRX_HEADER_ID. All queries should include ORG_ID and ENABLED_FLAG predicates to satisfy multi-org access and to restrict output to active lines.