DOO_DOC_REFERENCES_DROPSHIP_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: DOO
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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' |