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: GMS.GMS_DISTRIBUTION_DETAILS

Object Details

Object Name:	GMS_DISTRIBUTION_DETAILS
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_DISTRIBUTION_DETAILS
Subobject Name:
Status:	VALID

GMS_DISTRIBUTION_DETAILS stores records for actual award distribution and needs to be applied to the transaction record populated with the default award defined in Grants implementation setup. This table stores the detail records for GMS_DISTRIBUTIONS.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_DISTRIBUTION_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DOCUMENT_DISTRIBUTION_ID DOCUMENT_HEADER_ID DOCUMENT_TYPE
GMS_DISTRIBUTION_DETAILS_U1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DISTRIBUTION_NUMBER DOCUMENT_DISTRIBUTION_ID DOCUMENT_HEADER_ID DOCUMENT_TYPE FUNDING_PATTERN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_HEADER_ID	NUMBER	(15)	Yes	Sequence generated number uniquely identifies the funding header id.
DOCUMENT_DISTRIBUTION_ID	NUMBER		Yes	Detail Line information for the distribution lines
DOCUMENT_TYPE	VARCHAR2	(3)	Yes	Information from where the document originated
FUNDING_PATTERN_ID	NUMBER	(15)	Yes	Identifying the funding pattern
DISTRIBUTION_NUMBER	NUMBER	(15)	Yes	Distribution line number
AWARD_ID	NUMBER	(15)	Yes	Award information
PROJECT_ID	NUMBER	(15)	Yes	Project Information
TASK_ID	NUMBER	(15)	Yes	Task information for the project and award
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure Type information
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes	Information about expenditure organization
EXPENDITURE_ITEM_DATE	DATE		Yes	Expenditure Item Date
GL_DATE	DATE		Yes	GL Date
QUANTITY_DISTRIBUTED	NUMBER			Quantity of the items
AMOUNT_DISTRIBUTED	NUMBER		Yes	Amount of the items
FC_STATUS	VARCHAR2	(1)	Yes	Funds check status from GMS fund checker
LINE_STATUS	VARCHAR2	(30)		Status of the distribution line
REMARKS	VARCHAR2	(240)		Description of the failure
CREATION_DATE	DATE		Yes	Standard Who Column
BURDENED_COST	NUMBER			Burdened Cost
DENOM_BURDENED_COST	NUMBER			Burdened cost in Transaction currency
DENOM_RAW_COST	NUMBER			Raw Cost in Transaction currency
ACCT_RAW_COST	NUMBER			Raw Cost in functional currency
ACCT_BURDENED_COST	NUMBER			Burdened cost in functional currency
RECEIPT_CURRENCY_AMOUNT	NUMBER			Receipt currency amount of the transaction

Query Text

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


SELECT DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_TYPE
,      FUNDING_PATTERN_ID
,      DISTRIBUTION_NUMBER
,      AWARD_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ITEM_DATE
,      GL_DATE
,      QUANTITY_DISTRIBUTED
,      AMOUNT_DISTRIBUTED
,      FC_STATUS
,      LINE_STATUS
,      REMARKS
,      CREATION_DATE
,      BURDENED_COST
,      DENOM_BURDENED_COST
,      DENOM_RAW_COST
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      RECEIPT_CURRENCY_AMOUNT
FROM GMS.GMS_DISTRIBUTION_DETAILS;

Dependencies

[top of page]

GMS.GMS_DISTRIBUTION_DETAILS does not reference any database object

GMS.GMS_DISTRIBUTION_DETAILS is referenced by following:

APPS: GMS_DISTRIBUTION_DETAILS