1. Tables and Views for SCM
  2. DOS_SUPPLY_MAKE_ORDER_DTLS_V

DOS_SUPPLY_MAKE_ORDER_DTLS_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

ACCOUNTING_CLASS_CODE

ALT_BOM_DESIGNATOR

ALT_ROUTING_DESIGNATOR

BOM_REVISION_DATE

BUILD_SEQUENCE

CHARGE_ACCT_ID

CREATED_BY

CREATION_DATE

DEMAND_CLASS

GROUP_ID

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

LOAD_TYPE

NET_QUANTITY

OBJECT_VERSION_NUMBER

ROUTING_REVISION_DATE

SCHEDULE_GRP_ID

SUPPLY_MAKE_DETAILS_ID

TRACKING_LINE_ID

FIRM_PLANNED_FLAG

DELIVER_TO_SUBINVENTORY

WORK_ORDER_COMPLETION_DATE

WORK_ORDER_START_DATE

WORK_ORDER_DESCRIPTION

NET_QUANTITY_UOM_CODE

CHANGE_SUPPLY_OPERATION

EXEC_SYSTEM_COMPL_LOCTR_CODE

PRIMARY_DOC_QUANTITY

PRIMARY_DOC_QUANTITY_UOM

Query

SQL_Statement

SELECT ACCOUNTING_CLASS_CODE,

ALT_BOM_DESIGNATOR,

ALT_ROUTING_DESIGNATOR,

BOM_REVISION_DATE,

BUILD_SEQUENCE,

CHARGE_ACCT_ID,

CREATED_BY,

CREATION_DATE,

DEMAND_CLASS,

GROUP_ID,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

LAST_UPDATED_BY,

LOAD_TYPE,

NET_QUANTITY,

OBJECT_VERSION_NUMBER,

ROUTING_REVISION_DATE,

SCHEDULE_GRP_ID,

SUPPLY_MAKE_DETAILS_ID,

TRACKING_LINE_ID,

FIRM_PLANNED_FLAG,

DELIVER_TO_SUBINVENTORY,

WORK_ORDER_COMPLETION_DATE,

WORK_ORDER_START_DATE,

WORK_ORDER_DESCRIPTION,

NET_QUANTITY_UOM_CODE,

CHANGE_SUPPLY_OPERATION,

EXEC_SYSTEM_COMPL_LOCTR_CODE,

PRIMARY_DOC_QUANTITY,

PRIMARY_DOC_QUANTITY_UOM

FROM DOS_SUPPLY_MAKE_ORDER_DTLS