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 NULL AS DOC_SYSTEM_REF_ID, NULL AS HEADER_ID, NULL AS LINE_ID, DSL.SUPPLY_ORDER_REFERENCE_LINE_ID AS FULFILL_LINE_ID, NULL AS OWNER_TABLE_NAME, NULL AS OWNER_TABLE_ID, 'SUPPLY_ORDER' AS DOC_REF_TYPE, NULL AS DOC_ID, NULL AS DOC_CONTEXT_ID, DSH.SUPPLY_ORDER_NUMBER AS DOC_USER_KEY, NULL AS DOC_ALT_USER_KEY, NULL AS DOC_LINE_ID, NULL AS DOC_LINE_CONTEXT_ID, NULL AS DOC_LINE_USER_KEY, NULL AS DOC_LINE_ALT_USER_KEY, NULL AS DOC_SUBLINE_ID, NULL AS DOC_SUBLINE_CONTEXT_ID, NULL AS DOC_SUBLINE_USER_KEY, NULL AS DOC_SUBLINE_ALT_USER_KEY, NULL AS REFERENCE_DOC_SYSTEM_REF_ID, NULL AS TASK_TYPE FROM DOS_SUPPLY_LINES DSL, DOS_SUPPLY_HEADERS DSH, DOS_SUPPLY_TRACKING_LINES DSTL WHERE DSH.HEADER_ID = DSL.HEADER_ID AND DSL.LINE_ID = DSTL.LINE_ID AND DSTL.TERMINATED_FLAG <> 'Y' AND DSTL.CANCELED_FLAG <> 'Y'