View: WIPBV_JOB_CLOSE_VARIANCE_TXNS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPBV_JOB_CLOSE_VARIANCE_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 /* 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 = 6
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