DOO_DOC_REFERENCES_DROPSHIP_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 = 'DROPSHIP_PO_REFERENCE'