1. Tables and Views for SCM
  2. DOS_SUPPLY_TRACKING_LINE_DOC_V

DOS_SUPPLY_TRACKING_LINE_DOC_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

TRACKING_LINE_DOCS_ID

TRACKING_LINE_ID

OBJECT_VERSION_NUMBER

DOCUMENT_TYPE

DOCUMENT_NUMBER

DOCUMENT_STATUS

DOCUMENT_HEADER_ID

DOCUMENT_LINE_ID

STATUS_AS_OF_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

COMMENTS

DOCUMENT_LINE_NUMBER

DOCUMENT_LINE_QUANTITY

HEADER_ID

LINE_ID

DOCUMENT_LINE_UOM

TARGET_SERVICE_NAME

ACTIVE_FLAG

DOCUMENT_LINE_SECONDARY_QTY

DOCUMENT_LINE_SECONDARY_UOM

PARENT_TRACKING_LINE_DOCS_ID

TASK_OPERATION

TASK_TYPE

DOCUMENT_NET_QUANTITY

DOCUMENT_NET_QUANTITY_UOM

EXTERNAL_REFERENCE_ID

SOURCE_SYSTEM_ID

Query

SQL_Statement

SELECT TRACKING_LINE_DOCS_ID,

TRACKING_LINE_ID,

OBJECT_VERSION_NUMBER,

DOCUMENT_TYPE,

DOCUMENT_NUMBER,

DOCUMENT_STATUS,

DOCUMENT_HEADER_ID,

DOCUMENT_LINE_ID,

STATUS_AS_OF_DATE,

CREATED_BY,

CREATION_DATE,

LAST_UPDATED_BY,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

COMMENTS,

DOCUMENT_LINE_NUMBER,

DOCUMENT_LINE_QUANTITY,

HEADER_ID,

LINE_ID,

DOCUMENT_LINE_UOM,

TARGET_SERVICE_NAME,

ACTIVE_FLAG,

DOCUMENT_LINE_SECONDARY_QTY,

DOCUMENT_LINE_SECONDARY_UOM,

PARENT_TRACKING_LINE_DOCS_ID,

TASK_OPERATION,

TASK_TYPE,

DOCUMENT_NET_QUANTITY,

DOCUMENT_NET_QUANTITY_UOM,

EXTERNAL_REFERENCE_ID,

SOURCE_SYSTEM_ID

FROM DOS_SUPPLY_TRACKING_LINE_DOCS