DOO_DOCUMENT_REFERENCES_V

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

DOC_ALT_USER_KEY

DOC_CONTEXT_ID

DOC_ID

DOC_LINE_ALT_USER_KEY

DOC_LINE_CONTEXT_ID

DOC_LINE_ID

DOC_LINE_USER_KEY

DOC_REF_TYPE

DOC_SUBLINE_ALT_USER_KEY

DOC_SUBLINE_CONTEXT_ID

DOC_SUBLINE_ID

DOC_SUBLINE_USER_KEY

DOC_SYSTEM_REF_ID

DOC_USER_KEY

FULFILL_LINE_ID

HEADER_ID

OWNER_TABLE_ID

OWNER_TABLE_NAME

TASK_TYPE

Query

SQL_Statement

SELECT

DDR.DOC_ALT_USER_KEY,

DDR.DOC_CONTEXT_ID,

DDR.DOC_ID,

DDR.DOC_LINE_ALT_USER_KEY,

DDR.DOC_LINE_CONTEXT_ID,

DDR.DOC_LINE_ID,

DDR.DOC_LINE_USER_KEY,

DDR.DOC_REF_TYPE,

DDR.DOC_SUBLINE_ALT_USER_KEY,

DDR.DOC_SUBLINE_CONTEXT_ID,

DDR.DOC_SUBLINE_ID,

DDR.DOC_SUBLINE_USER_KEY,

DDR.DOC_SYSTEM_REF_ID,

DDR.DOC_USER_KEY,

DDR.FULFILL_LINE_ID,

DDR.HEADER_ID,

DDR.OWNER_TABLE_ID,

DDR.OWNER_TABLE_NAME,

DDR.TASK_TYPE

FROM DOO_DOCUMENT_REFERENCES DDR