[Home] [Help]
View: CUN_TRANSACTION_HIST_V
Product: | CUN - Network Logistics - NATS (Obsolete) |
Description: | Business view of the transaction history for transaction type 'ISSUE_TO_PROJECT' |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CTR.ORGANIZATION_ID
, CTR.ITEM_ID
, CTR.PROJECT_ID
, CTR.TASK_ID
, CTR.TRANSACTION_TYPE
, CTR.WORK_ORDER_NUMBER
, CTR.MTL_TRANSACTION_ID
, CTR.TRANSACTION_ID
FROM CUN_TRANSACTIONS CTR CONNECT BY PRIOR LAST_TRANSACTION_ID = TRANSACTION_ID START WITH TRANSACTION_ID = (SELECT LAST_TRANSACTION_ID
FROM CUN_ITEMS_V CUV
WHERE CUV.INV_ITEM_ID=CTR.ITEM_ID
AND CUV.INVENTORY_ORG_ID=CTR.ORGANIZATION_ID)
AND CTR.TRANSACTION_TYPE = 'ISSUE_TO_PROJECT'
Columns
Name |
ORGANIZATION_ID |
ITEM_ID |
PROJECT_ID |
TASK_ID |
TRANSACTION_TYPE |
WORK_ORDER_NUMBER |
MTL_TRANSACTION_ID |
TRANSACTION_ID |