[Home] [Help]
View: WIPBV_PERIOD_CLOSE_VAR_TXNS
View Text
SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID
, '_LA:TRANSACTION_TYPE:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING'
, TR.TRANSACTION_DATE
, TR.SOURCE_CODE
, TR.REFERENCE /* IDS */
, TR.ORGANIZATION_ID
, TR.WIP_ENTITY_ID
, TR.ACCT_PERIOD_ID
, TR.LINE_ID
, TR.REASON_ID /* WHO */
, TR.CREATION_DATE
, TR.CREATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY
FROM WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 5
AND '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
| Name |
| TRANSACTION_ID |
| "_LA:TRANSACTION_TYPE" |
| TRANSACTION_DATE |
| SOURCE_CODE |
| DESCRIPTION |
| ORGANIZATION_ID |
| MFG_ORDER_ID |
| ACCT_PERIOD_ID |
| LINE_ID |
| REASON_ID |
| CREATED_DATE |
| CREATED_BY |
| UPDATED_DATE |
| UPDATED_BY |