DOS_SUPPLY_HEADERS_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

HEADER_ID

OBJECT_VERSION_NUMBER

SUPPLY_ORDER_NUMBER

SUPPLY_ORDER_SOURCE

SUPPLY_REQUEST_DATE

SUPPLY_ORDER_REFERENCE_NUMBER

SUPPLY_ORDER_REFERENCE_ID

TRUSTED_SOURCE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

STATUS_CODE

INTERFACE_BATCH_NAME

INTERFACE_BATCH_NUMBER

SOURCE_REF_DOC_DESCRIPTION

Query

SQL_Statement

SELECT HEADER_ID,

OBJECT_VERSION_NUMBER,

SUPPLY_ORDER_NUMBER,

SUPPLY_ORDER_SOURCE,

SUPPLY_REQUEST_DATE,

SUPPLY_ORDER_REFERENCE_NUMBER,

SUPPLY_ORDER_REFERENCE_ID,

TRUSTED_SOURCE,

CREATED_BY,

CREATION_DATE,

LAST_UPDATED_BY,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

STATUS_CODE,

INTERFACE_BATCH_NAME,

INTERFACE_BATCH_NUMBER,

SOURCE_REF_DOC_DESCRIPTION

FROM DOS_SUPPLY_HEADERS