View: WIPBV_MFG_COST_UPDATE_TXNS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPBV_MFG_COST_UPDATE_TXNS

View Text

SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID
, LO.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
, TR.COST_UPDATE_ID /* WHO */
, TR.CREATION_DATE
, TR.CREATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY
FROM MFG_LOOKUPS LO
, WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 4
AND LO.LOOKUP_CODE = TR.TRANSACTION_TYPE
AND LO.LOOKUP_TYPE = 'WIP_TRANSACTION_TYPE'
AND '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns