Search Results jai_rgm_dis_des_hdrs




Overview
Explore in AI Chat

Overview

The JAI_RGM_DIS_DES_HDRS table is a core data object within the Asia/Pacific Localizations (product code JA) of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a header-level repository for recording the destination details in a goods transfer process. Specifically, it stores the organizational and party information for the entity that is designated to receive a transfer, as part of a localized regulatory or business flow. Its primary role is to establish and maintain the destination side of a transfer transaction, linking to source headers and detailed tax information to form a complete transfer record compliant with regional requirements.

Key Information Stored

The table's structure is centered on a unique identifier and key foreign key relationships. The primary column is TRANSFER_DESTINATION_ID, which serves as the unique primary key for each destination record. Other critical columns establish links to related entities: TRANSFER_ID connects the destination to its corresponding source header record in JAI_RGM_DIS_SRC_HDRS, defining the overall transfer. TRANSFER_SOURCE_ID provides a more granular link to source tax details. The DESTINATION_PARTY_ID column holds a reference to the trading partner or legal entity receiving the goods via the HZ_PARTIES table, while LOCATION_ID specifies the precise physical or operational site for the destination using the HR_LOCATIONS_ALL table.

Common Use Cases and Queries

This table is integral to generating reports on inter-organization or inter-company transfers for tax and compliance purposes within the Asia/Pacific region. A common operational use case involves querying all destination details for a specific transfer to validate or audit shipment information. For reporting, a join to the source headers and parties table is typical to present a complete transfer document.

  • Retrieving destination details for a specific transfer: SELECT * FROM JAI_RGM_DIS_DES_HDRS WHERE TRANSFER_ID = :p_transfer_id;
  • Generating a transfer summary report: SELECT src.attribute1, des.*, party.party_name FROM JAI_RGM_DIS_SRC_HDRS src, JAI_RGM_DIS_DES_HDRS des, HZ_PARTIES party WHERE src.TRANSFER_ID = des.TRANSFER_ID AND des.DESTINATION_PARTY_ID = party.party_id;
  • Identifying all transfers destined for a particular location: SELECT * FROM JAI_RGM_DIS_DES_HDRS WHERE LOCATION_ID = :p_location_id;

Related Objects

The JAI_RGM_DIS_DES_HDRS table exists within a tightly defined schema, with documented relationships to several other EBS objects. It references four key tables as a child entity and is itself referenced as a parent.

  • Referenced By (Parent Tables):
    • JAI_RGM_DIS_SRC_HDRS: Linked via JAI_RGM_DIS_DES_HDRS.TRANSFER_ID. This is the primary relationship defining the transfer.
    • JAI_RGM_DIS_SRC_TAXES: Linked via JAI_RGM_DIS_DES_HDRS.TRANSFER_SOURCE_ID.
    • HR_LOCATIONS_ALL: Linked via JAI_RGM_DIS_DES_HDRS.LOCATION_ID.
    • HZ_PARTIES: Linked via JAI_RGM_DIS_DES_HDRS.DESTINATION_PARTY_ID.
  • Referenced In (Child Table):
    • JAI_RGM_DIS_DES_TAXES: This table references JAI_RGM_DIS_DES_HDRS via JAI_RGM_DIS_DES_TAXES.TRANSFER_DESTINATION_ID, storing detailed tax information specific to the destination.