eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: JA.JAI_RGM_DIS_DES_HDRS

Object Details

Object Name:	JAI_RGM_DIS_DES_HDRS
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_RGM_DIS_DES_HDRS
Subobject Name:
Status:	VALID

This table has the details of the destination organization which will receive the transfer.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RGM_DIS_DES_HDRS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSFER_DESTINATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSFER_ID	NUMBER			Internal Identifier for the distribution transction.
TRANSFER_SOURCE_ID	NUMBER			Internal Identifier for the source record from where transfer is being done.
TRANSFER_DESTINATION_ID	NUMBER		Yes	Unique Identifier for the table.
DESTINATION_PARTY_TYPE	VARCHAR2	(30)		Possible values are "IO" for Inventory Organization and "OU" for Operating Unit.
DESTINATION_PARTY_ID	NUMBER			It has the Inventory Organization identifier or Operating Unit Identifier.
LOCATION_ID	NUMBER			It has the Location Identifier of the location where the transfer occured.
AMOUNT_TO_TRANSFER	NUMBER			The amount to be received by the receiving organization.
TRANSFER_NUMBER	VARCHAR2	(30)		A Unique number that identifies the transfer destination record
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSFER_ID
,      TRANSFER_SOURCE_ID
,      TRANSFER_DESTINATION_ID
,      DESTINATION_PARTY_TYPE
,      DESTINATION_PARTY_ID
,      LOCATION_ID
,      AMOUNT_TO_TRANSFER
,      TRANSFER_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RGM_DIS_DES_HDRS;

Dependencies

[top of page]

JA.JAI_RGM_DIS_DES_HDRS does not reference any database object

JA.JAI_RGM_DIS_DES_HDRS is referenced by following:

APPS: JAI_RGM_DIS_DES_HDRS