SCH_REC_STATUS_DETAILS

Details

Schema: FUSION
Object owner: SCH
Object type: VIEW

Columns

Name
PRODUCT_TRACE_ID INVENTORY_ITEM_ID INVENTORY_ORGANIZATION_ID PRODUCT_TRACE_LINE_ID LOT_NUMBER SERIAL_NUMBER PRIMARY_UOM_CODE PRIMARY_TRANSACTION_QTY SHIPMENT_NUMBER EXPECTED_RECEIPT_DATE RECEIPT_NUMBER RECEIPT_DATE ONHAND_QTY CONSIGNED_QTY DELIVER_TO_LOCATION_ID SUBINVENTORY LOCATOR_ID PRIMARY_COUNT_QTY SALES_ORDER_NUMBER SALES_ORDER_LINE_NUMBER OBJECT_VERSION_NUMBER REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN TRANSACTION_TYPE_ID TRANSACTION_DATE EXPENSE_ACCOUNT_ID REQUISITION_LINE_NUMBER PURCHASE_ORDER PO_LINE_NUMBER OWNING_ENTITY_ID TRANSFER_ORDER_NUMBER TRANSFER_ORDER_LINE_NUMBER SECONDARY_UOM_CODE SECONDARY_TRANSACTION_QTY SECONDARY_ONHAND_QTY REQUISITION_NUMBER

Name

PRODUCT_TRACE_ID

INVENTORY_ITEM_ID

INVENTORY_ORGANIZATION_ID

PRODUCT_TRACE_LINE_ID

LOT_NUMBER

SERIAL_NUMBER

PRIMARY_UOM_CODE

PRIMARY_TRANSACTION_QTY

SHIPMENT_NUMBER

EXPECTED_RECEIPT_DATE

RECEIPT_NUMBER

RECEIPT_DATE

ONHAND_QTY

CONSIGNED_QTY

DELIVER_TO_LOCATION_ID

SUBINVENTORY

LOCATOR_ID

PRIMARY_COUNT_QTY

SALES_ORDER_NUMBER

SALES_ORDER_LINE_NUMBER

OBJECT_VERSION_NUMBER

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

TRANSACTION_TYPE_ID

TRANSACTION_DATE

EXPENSE_ACCOUNT_ID

REQUISITION_LINE_NUMBER

PURCHASE_ORDER

PO_LINE_NUMBER

OWNING_ENTITY_ID

TRANSFER_ORDER_NUMBER

TRANSFER_ORDER_LINE_NUMBER

SECONDARY_UOM_CODE

SECONDARY_TRANSACTION_QTY

SECONDARY_ONHAND_QTY

REQUISITION_NUMBER

Query

SQL_Statement
SELECT SCH_REC_TRACE_STATUS.PRODUCT_TRACE_ID, SCH_REC_TRACE_STATUS.INVENTORY_ITEM_ID, SCH_REC_TRACE_STATUS.INVENTORY_ORGANIZATION_ID, SCH_REC_TRACE_DETAILS.PRODUCT_TRACE_LINE_ID, SCH_REC_TRACE_DETAILS.LOT_NUMBER, SCH_REC_TRACE_DETAILS.SERIAL_NUMBER, SCH_REC_TRACE_DETAILS.PRIMARY_UOM_CODE, SCH_REC_TRACE_DETAILS.PRIMARY_TRANSACTION_QTY, SCH_REC_TRACE_DETAILS.SHIPMENT_NUMBER, SCH_REC_TRACE_DETAILS.EXPECTED_RECEIPT_DATE, SCH_REC_TRACE_DETAILS.RECEIPT_NUMBER, SCH_REC_TRACE_DETAILS.RECEIPT_DATE, SCH_REC_TRACE_DETAILS.ONHAND_QTY, SCH_REC_TRACE_DETAILS.CONSIGNED_QTY, SCH_REC_TRACE_DETAILS.DELIVER_TO_LOCATION_ID, SCH_REC_TRACE_DETAILS.SUBINVENTORY, SCH_REC_TRACE_DETAILS.LOCATOR_ID, SCH_REC_TRACE_DETAILS.PRIMARY_COUNT_QTY, SCH_REC_TRACE_DETAILS.SALES_ORDER_NUMBER, SCH_REC_TRACE_DETAILS.SALES_ORDER_LINE_NUMBER, SCH_REC_TRACE_DETAILS.OBJECT_VERSION_NUMBER, SCH_REC_TRACE_DETAILS.REQUEST_ID, SCH_REC_TRACE_DETAILS.JOB_DEFINITION_NAME, SCH_REC_TRACE_DETAILS.JOB_DEFINITION_PACKAGE, SCH_REC_TRACE_DETAILS.CREATION_DATE, SCH_REC_TRACE_DETAILS.CREATED_BY, SCH_REC_TRACE_DETAILS.LAST_UPDATE_DATE, SCH_REC_TRACE_DETAILS.LAST_UPDATED_BY, SCH_REC_TRACE_DETAILS.LAST_UPDATE_LOGIN, SCH_REC_TRACE_DETAILS.TRANSACTION_TYPE_ID, SCH_REC_TRACE_DETAILS.TRANSACTION_DATE, SCH_REC_TRACE_DETAILS.EXPENSE_ACCOUNT_ID, SCH_REC_TRACE_DETAILS.REQUISITION_LINE_NUMBER, SCH_REC_TRACE_DETAILS.PURCHASE_ORDER, SCH_REC_TRACE_DETAILS.PO_LINE_NUMBER, SCH_REC_TRACE_DETAILS.OWNING_ENTITY_ID, SCH_REC_TRACE_DETAILS.TRANSFER_ORDER_NUMBER, SCH_REC_TRACE_DETAILS.TRANSFER_ORDER_LINE_NUMBER, SCH_REC_TRACE_DETAILS.SECONDARY_UOM_CODE, SCH_REC_TRACE_DETAILS.SECONDARY_TRANSACTION_QTY, SCH_REC_TRACE_DETAILS.SECONDARY_ONHAND_QTY, SCH_REC_TRACE_DETAILS.REQUISITION_NUMBER from SCH_REC_TRACE_STATUS,SCH_REC_TRACE_DETAILS WHERE SCH_REC_TRACE_DETAILS.PRODUCT_TRACE_ID= SCH_REC_TRACE_STATUS.PRODUCT_TRACE_ID

SQL_Statement

SELECT

SCH_REC_TRACE_STATUS.PRODUCT_TRACE_ID,

SCH_REC_TRACE_STATUS.INVENTORY_ITEM_ID,

SCH_REC_TRACE_STATUS.INVENTORY_ORGANIZATION_ID,

SCH_REC_TRACE_DETAILS.PRODUCT_TRACE_LINE_ID,

SCH_REC_TRACE_DETAILS.LOT_NUMBER,

SCH_REC_TRACE_DETAILS.SERIAL_NUMBER,

SCH_REC_TRACE_DETAILS.PRIMARY_UOM_CODE,

SCH_REC_TRACE_DETAILS.PRIMARY_TRANSACTION_QTY,

SCH_REC_TRACE_DETAILS.SHIPMENT_NUMBER,

SCH_REC_TRACE_DETAILS.EXPECTED_RECEIPT_DATE,

SCH_REC_TRACE_DETAILS.RECEIPT_NUMBER,

SCH_REC_TRACE_DETAILS.RECEIPT_DATE,

SCH_REC_TRACE_DETAILS.ONHAND_QTY,

SCH_REC_TRACE_DETAILS.CONSIGNED_QTY,

SCH_REC_TRACE_DETAILS.DELIVER_TO_LOCATION_ID,

SCH_REC_TRACE_DETAILS.SUBINVENTORY,

SCH_REC_TRACE_DETAILS.LOCATOR_ID,

SCH_REC_TRACE_DETAILS.PRIMARY_COUNT_QTY,

SCH_REC_TRACE_DETAILS.SALES_ORDER_NUMBER,

SCH_REC_TRACE_DETAILS.SALES_ORDER_LINE_NUMBER,

SCH_REC_TRACE_DETAILS.OBJECT_VERSION_NUMBER,

SCH_REC_TRACE_DETAILS.REQUEST_ID,

SCH_REC_TRACE_DETAILS.JOB_DEFINITION_NAME,

SCH_REC_TRACE_DETAILS.JOB_DEFINITION_PACKAGE,

SCH_REC_TRACE_DETAILS.CREATION_DATE,

SCH_REC_TRACE_DETAILS.CREATED_BY,

SCH_REC_TRACE_DETAILS.LAST_UPDATE_DATE,

SCH_REC_TRACE_DETAILS.LAST_UPDATED_BY,

SCH_REC_TRACE_DETAILS.LAST_UPDATE_LOGIN,

SCH_REC_TRACE_DETAILS.TRANSACTION_TYPE_ID,

SCH_REC_TRACE_DETAILS.TRANSACTION_DATE,

SCH_REC_TRACE_DETAILS.EXPENSE_ACCOUNT_ID,

SCH_REC_TRACE_DETAILS.REQUISITION_LINE_NUMBER,

SCH_REC_TRACE_DETAILS.PURCHASE_ORDER,

SCH_REC_TRACE_DETAILS.PO_LINE_NUMBER,

SCH_REC_TRACE_DETAILS.OWNING_ENTITY_ID,

SCH_REC_TRACE_DETAILS.TRANSFER_ORDER_NUMBER,

SCH_REC_TRACE_DETAILS.TRANSFER_ORDER_LINE_NUMBER,

SCH_REC_TRACE_DETAILS.SECONDARY_UOM_CODE,

SCH_REC_TRACE_DETAILS.SECONDARY_TRANSACTION_QTY,

SCH_REC_TRACE_DETAILS.SECONDARY_ONHAND_QTY,

SCH_REC_TRACE_DETAILS.REQUISITION_NUMBER

from SCH_REC_TRACE_STATUS,SCH_REC_TRACE_DETAILS

WHERE SCH_REC_TRACE_DETAILS.PRODUCT_TRACE_ID= SCH_REC_TRACE_STATUS.PRODUCT_TRACE_ID