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