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