DOO_DOC_REFERENCES_SUPPLY_V
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: VIEW
Columns
Name |
---|
DOC_SYSTEM_REF_ID HEADER_ID LINE_ID FULFILL_LINE_ID OWNER_TABLE_NAME OWNER_TABLE_ID DOC_REF_TYPE DOC_ID DOC_CONTEXT_ID DOC_USER_KEY DOC_ALT_USER_KEY DOC_LINE_ID DOC_LINE_CONTEXT_ID DOC_LINE_USER_KEY DOC_LINE_ALT_USER_KEY DOC_SUBLINE_ID DOC_SUBLINE_CONTEXT_ID DOC_SUBLINE_USER_KEY DOC_SUBLINE_ALT_USER_KEY REFERENCE_DOC_SYSTEM_REF_ID TASK_TYPE |
Query
SQL_Statement |
---|
SELECT DOO_DOCUMENT_REFERENCES.DOC_SYSTEM_REF_ID, DOO_DOCUMENT_REFERENCES.HEADER_ID, DOO_DOCUMENT_REFERENCES.LINE_ID, DOO_DOCUMENT_REFERENCES.FULFILL_LINE_ID, DOO_DOCUMENT_REFERENCES.OWNER_TABLE_NAME, DOO_DOCUMENT_REFERENCES.OWNER_TABLE_ID, DOO_DOCUMENT_REFERENCES.DOC_REF_TYPE, DOO_DOCUMENT_REFERENCES.DOC_ID, DOO_DOCUMENT_REFERENCES.DOC_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_LINE_ID, DOO_DOCUMENT_REFERENCES.DOC_LINE_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_LINE_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_LINE_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_ID, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.REFERENCE_DOC_SYSTEM_REF_ID, DOO_DOCUMENT_REFERENCES.TASK_TYPE FROM DOO_DOCUMENT_REFERENCES WHERE DOO_DOCUMENT_REFERENCES.DOC_REF_TYPE = 'SUPPLY_ORDER' |