SCH_REC_STATUS_DETAILS_V
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 |
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 |