VIEW: APPS.WIPFV_JOB_CLOSE_VARIANCE_TXNS

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID , LO.MEANING , TR.TRANSACTION_DATE , TR.SOURCE_CODE , TR.REFERENCE /* FOREIGN KEYS RESOLVED */ , PA.ORGANIZATION_CODE , AL.NAME , EN.WIP_ENTITY_NAME , AC.PERIOD_NAME , '_DF:WIP:WIP_TRANSACTIONS:tr' /* IDS */ , TR.ORGANIZATION_ID , TR.WIP_ENTITY_ID , TR.ACCT_PERIOD_ID , TR.SOURCE_LINE_ID /* WHO */ , TR.CREATION_DATE , TR.CREATED_BY , TR.LAST_UPDATE_DATE , TR.LAST_UPDATED_BY FROM MTL_TRANSACTION_REASONS MTR , MFG_LOOKUPS LO , WIP_ENTITIES EN , ORG_ACCT_PERIODS AC , HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , WIP_TRANSACTIONS TR WHERE TR.TRANSACTION_TYPE = 6 AND TR.ORGANIZATION_ID = PA.ORGANIZATION_ID AND TR.ORGANIZATION_ID = AL.ORGANIZATION_ID AND TR.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND TR.ORGANIZATION_ID = EN.ORGANIZATION_ID AND TR.ACCT_PERIOD_ID = AC.ACCT_PERIOD_ID AND TR.ORGANIZATION_ID = AC.ORGANIZATION_ID AND LO.LOOKUP_CODE = TR.TRANSACTION_TYPE AND LO.LOOKUP_TYPE = 'WIP_TRANSACTION_TYPE' AND TR.REASON_ID = MTR.REASON_ID (+) AND '_SEC:tr.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID
, LO.MEANING
, TR.TRANSACTION_DATE
, TR.SOURCE_CODE
, TR.REFERENCE /* FOREIGN KEYS RESOLVED */
, PA.ORGANIZATION_CODE
, AL.NAME
, EN.WIP_ENTITY_NAME
, AC.PERIOD_NAME
, '_DF:WIP:WIP_TRANSACTIONS:TR' /* IDS */
, TR.ORGANIZATION_ID
, TR.WIP_ENTITY_ID
, TR.ACCT_PERIOD_ID
, TR.SOURCE_LINE_ID /* WHO */
, TR.CREATION_DATE
, TR.CREATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY
FROM MTL_TRANSACTION_REASONS MTR
, MFG_LOOKUPS LO
, WIP_ENTITIES EN
, ORG_ACCT_PERIODS AC
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 6
AND TR.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND TR.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND TR.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND TR.ORGANIZATION_ID = EN.ORGANIZATION_ID
AND TR.ACCT_PERIOD_ID = AC.ACCT_PERIOD_ID
AND TR.ORGANIZATION_ID = AC.ORGANIZATION_ID
AND LO.LOOKUP_CODE = TR.TRANSACTION_TYPE
AND LO.LOOKUP_TYPE = 'WIP_TRANSACTION_TYPE'
AND TR.REASON_ID = MTR.REASON_ID (+)
AND '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY