VIEW: APPS.WIPBV_PERIOD_CLOSE_VAR_TXNS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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