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

VIEW: GMS.GMS_DISTRIBUTION_DETAILS#

Object Details
Object Name: GMS_DISTRIBUTION_DETAILS#
Object Type: VIEW
Owner: GMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_HEADER_ID NUMBER (15) Yes
DOCUMENT_DISTRIBUTION_ID NUMBER
Yes
DOCUMENT_TYPE VARCHAR2 (3) Yes
FUNDING_PATTERN_ID NUMBER (15) Yes
DISTRIBUTION_NUMBER NUMBER (15) Yes
AWARD_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
TASK_ID NUMBER (15) Yes
EXPENDITURE_TYPE VARCHAR2 (30) Yes
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Yes
EXPENDITURE_ITEM_DATE DATE
Yes
GL_DATE DATE
Yes
QUANTITY_DISTRIBUTED NUMBER

AMOUNT_DISTRIBUTED NUMBER
Yes
FC_STATUS VARCHAR2 (1) Yes
LINE_STATUS VARCHAR2 (30)
REMARKS VARCHAR2 (240)
CREATION_DATE DATE
Yes
BURDENED_COST NUMBER

DENOM_BURDENED_COST NUMBER

DENOM_RAW_COST NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

RECEIPT_CURRENCY_AMOUNT NUMBER

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# references the following:

SchemaGMS
TableGMS_DISTRIBUTION_DETAILS
GMS.GMS_DISTRIBUTION_DETAILS# is referenced by following:

SchemaAPPS
SynonymGMS_DISTRIBUTION_DETAILS