Product: | WIP - Work in Process |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WIPBV_WIP_MOVE_TRANSACTIONS |
SELECT TRANSACTION_DATE
, GROUP_ID
, FM_INTRAOPERATION_STEP_TYPE
, TO_INTRAOPERATION_STEP_TYPE
, TRANSACTION_QUANTITY
, REFERENCE
, PRIMARY_QUANTITY
, OVERCOMPLETION_TRANSACTION_QTY
, OVERCOMPLETION_PRIMARY_QTY
, TRANSACTION_ID
, FM_DEPARTMENT_ID
, TO_DEPARTMENT_ID
, ORGANIZATION_ID
, WIP_ENTITY_ID
, LINE_ID
, PRIMARY_ITEM_ID
, ACCT_PERIOD_ID
, FM_OPERATION_SEQ_NUM
, TO_OPERATION_SEQ_NUM
, TRANSACTION_UOM
, PRIMARY_UOM
, SCRAP_ACCOUNT_ID
, QA_COLLECTION_ID
, REASON_ID
, OVERCOMPLETION_TRANSACTION_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM WIP_MOVE_TRANSACTIONS
WHERE '_SEC:WIP_MOVE_TRANSACTIONS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY