Search Results ship_attribute3

Overview

APPS.JAI_RCV_CLAIM_MODVAT_V is a validity-checked Oracle E-Business Suite view owned by the APPS schema and registered in the applications design data as JA.JAI_RCV_CLAIM_MODVAT_V. It belongs to the India Localization (JAI) family of objects and consolidates receiving transaction data with the MODVAT/CENVAT excise claim information required for Indian indirect tax processing. The view exposes one row per receipt transaction line, joining core Oracle Purchasing receiving entities to the JAI CENVAT claim tables and JAI inventory organization setup so that duty credit eligibility, claimed amounts, and item classification can be reported together.

The object is documented as an Internal view type. Oracle's standard notice applies: Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. Consequently, reporting and integration should treat JAI_RCV_CLAIM_MODVAT_V as a read-only, localization-owned construct. It is available in both EBS 12.1.1 and 12.2.2, with the 12.2.2 metadata confirming the current referenced base objects. The user search term "ship_attribute1" corresponds directly to the SHIP_ATTRIBUTE1 column (VARCHAR2 150), which carries shipment-level descriptive attribute data used by Indian localization to hold claim-related or document reference identifiers alongside the receipt.

Underlying Base Objects

The 12.2.2 documented dependency list identifies the following referenced objects:

• HR_GENERAL (PACKAGE) - supplies organizational and business group context used in the view logic.
• HR_LOCATIONS (VIEW) - provides location and address details for vendors and sites.
• JAI_CMN_INVENTORY_ORGS (SYNONYM) - the localization inventory organization definition, used to restrict and qualify eligible organizations.
• JAI_INV_ITM_SETUPS (SYNONYM) - item-level MODVAT/CENVAT setup driving ITEM_MODVAT_FLAG and classification.
• JAI_INV_SUBINV_DTLS (SYNONYM) - subinventory-level detail supporting the destination and organization columns.
• JAI_RCV_CENVAT_CLAIMS (SYNONYM) - the CENVAT claim records supplying claimed amounts, percentages, and second-claim values.
• JAI_RCV_HEADERS (SYNONYM) and JAI_RCV_LINES (SYNONYM) - localization receiving header and line extensions that hold ATTRIBUTE1/2/3 and the MODVAT flags.
• RCV_SHIPMENT_LINES (SYNONYM) - shipment line detail, source of SHIP_ATTRIBUTE1 through SHIP_ATTRIBUTE3.
• RCV_TRANSACTIONS (SYNONYM) - base receiving transaction driving TRANSACTION_ID, TRANSACTION_TYPE, and TRANSACTION_DATE.

The view therefore unites the standard Purchasing receiving model with the India Localization tax extension tables, filtered by inventory organization setup.

Key Columns

• ROW_ID, RECEIPT_NUM, TRANSACTION_ID, TRANSACTION_TYPE - identity and transaction context from RCV_TRANSACTIONS.
• TRANSACTION_DATE, CREATION_DATE - receipt and record creation timestamps.
• VENDOR_ID, VENDOR_SITE_ID, LOCATION_ID, VENDOR_CHANGED_FLAG - supplier and site identification, with a flag indicating vendor change.
• SHIPMENT_LINE_ID, SHIPMENT_HEADER_ID - links to the shipment line and header.
• SHIP_ATTRIBUTE1 (VARCHAR2 150), SHIP_ATTRIBUTE2 (DATE), SHIP_ATTRIBUTE3 (VARCHAR2) - shipment-level descriptive attributes sourced from RCV_SHIPMENT_LINES.
• ATTRIBUTE1, ATTRIBUTE2 (DATE), ATTRIBUTE3 - localization receiving header/line descriptive flexfield values.
• QUANTITY, CATEGORY, ITEM_ID, ITEM_CLASS - item and quantity information.
• ITEM_MODVAT_FLAG, CLAIM_MODVAT_FLAG - eligibility indicators for MODVAT/CENVAT credit.
• CENVAT_AMOUNT, CENVAT_CLAIMED_AMT, CENVAT_CLAIMED_PTG - credit amount, claimed amount, and claimed percentage.
• OTHER_CENVAT_AMT, OTHER_CENVAT_CLAIMED_AMT and the *_FOR_2ND_CLAIM columns - additional and secondary claim amounts.
• CURRENCY_CONVERSION_RATE, TO_ORGANIZATION_ID, RECEIPT_SOURCE_CODE, DESTINATION_TYPE_CODE - conversion and destination context.

Common Use Cases and Queries

Typical scenarios include reconciling CENVAT claimed versus eligible amounts per receipt, validating item setup against actual claims, and extracting receipt data for indirect tax returns or third-party reporting. Because SHIP_ATTRIBUTE1 is frequently used to store claim or document references, it is a common filter.

SELECT receipt_num,
       transaction_id,
       ship_attribute1,
       item_id,
       item_modvat_flag,
       claim_modvat_flag,
       cenvat_amount,
       cenvat_claimed_amt,
       cenvat_claimed_ptg
FROM   apps.jai_rcv_claim_modvat_v
WHERE  transaction_date >= :p_from_date
AND    claim_modvat_flag = 'Y';

SELECT receipt_num,
       ship_attribute1,
       SUM(cenvat_claimed_amt) claimed
FROM   apps.jai_rcv_claim_modvat_v
WHERE  ship_attribute1 IS NOT NULL
GROUP  BY receipt_num, ship_attribute1;

Queries should be executed under a responsibility with India Localization access, and results treated as read-only reporting output per Oracle's internal-use restriction.