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

VIEW: GML.PO_DIST_DTL#

Object Details
Object Name: PO_DIST_DTL#
Object Type: VIEW
Owner: GML
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DOC_TYPE VARCHAR2 (4) Yes
DOC_ID NUMBER (10) Yes
LINE_ID NUMBER (10) Yes
RECV_SEQ_NO NUMBER (5) Yes
SEQ_NO NUMBER (5) Yes
AQUI_COST_ID NUMBER (10)
ITEM_ID NUMBER (10) Yes
ACCTG_UNIT_ID NUMBER (10) Yes
ACCT_ID NUMBER (10) Yes
ACCT_DESC VARCHAR2 (70) Yes
ACCT_TTL_TYPE NUMBER (5) Yes
AMOUNT_BASE NUMBER
Yes
AMOUNT_TRANS NUMBER
Yes
QUANTITY NUMBER
Yes
QUANTITY_UM VARCHAR2 (4) Yes
PROJECT_NO VARCHAR2 (16)
GL_POSTED_IND NUMBER (5) Yes
EXPORTED_DATE DATE
Yes
CURRENCY_TRANS VARCHAR2 (4) Yes
CURRENCY_BASE VARCHAR2 (4) Yes
CO_CODE VARCHAR2 (4) Yes
LEDGER_CODE VARCHAR2 (4) Yes
FISCAL_YEAR NUMBER (5) Yes
PERIOD NUMBER (5) Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
TRANS_CNT NUMBER (10)
TEXT_CODE NUMBER (10)
DELETE_MARK NUMBER (5) Yes
Query Text

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


SELECT DOC_TYPE
,      DOC_ID
,      LINE_ID
,      RECV_SEQ_NO
,      SEQ_NO
,      AQUI_COST_ID
,      ITEM_ID
,      ACCTG_UNIT_ID
,      ACCT_ID
,      ACCT_DESC
,      ACCT_TTL_TYPE
,      AMOUNT_BASE
,      AMOUNT_TRANS
,      QUANTITY
,      QUANTITY_UM
,      PROJECT_NO
,      GL_POSTED_IND
,      EXPORTED_DATE
,      CURRENCY_TRANS
,      CURRENCY_BASE
,      CO_CODE
,      LEDGER_CODE
,      FISCAL_YEAR
,      PERIOD
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GML.PO_DIST_DTL#;

Dependencies

[top of page]

GML.PO_DIST_DTL# references the following:

SchemaGML
TablePO_DIST_DTL
GML.PO_DIST_DTL# is referenced by following:

SchemaAPPS
SynonymPO_DIST_DTL