FND Design Data [Home] [Help]

View: WIPBV_PERIOD_CLOSE_VAR_TXNS

Product: WIP - Work in Process
Description:
Implementation/DBA Data: ViewAPPS.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