DBA Data[Home] [Help]

VIEW: APPS.WIPFV_MFG_COST_UPDATE_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 /* FOREIGN KEYS RESOLVED */ , PA.ORGANIZATION_CODE , AL.NAME , EN.WIP_ENTITY_NAME , LI.LINE_CODE , AC.PERIOD_NAME , MTR.REASON_NAME , '_DF:WIP:WIP_TRANSACTIONS:tr' /* IDS */ , TR.ORGANIZATION_ID , TR.WIP_ENTITY_ID , TR.LINE_ID , TR.ACCT_PERIOD_ID , TR.REASON_ID , TR.COST_UPDATE_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 , WIP_LINES LI , CST_COST_UPDATES CO , ORG_ACCT_PERIODS AC , WIP_ENTITIES EN , HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , WIP_TRANSACTIONS TR WHERE TR.TRANSACTION_TYPE = 4 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 TR.COST_UPDATE_ID = CO.COST_UPDATE_ID AND TR.LINE_ID = LI.LINE_ID (+) AND TR.ORGANIZATION_ID = LI.ORGANIZATION_ID (+) 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
, '_LA:TRANSACTION_TYPE:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING'
, TR.TRANSACTION_DATE
, TR.SOURCE_CODE
, TR.REFERENCE /* FOREIGN KEYS RESOLVED */
, PA.ORGANIZATION_CODE
, AL.NAME
, EN.WIP_ENTITY_NAME
, LI.LINE_CODE
, AC.PERIOD_NAME
, MTR.REASON_NAME
, '_DF:WIP:WIP_TRANSACTIONS:TR' /* IDS */
, TR.ORGANIZATION_ID
, TR.WIP_ENTITY_ID
, TR.LINE_ID
, TR.ACCT_PERIOD_ID
, TR.REASON_ID
, TR.COST_UPDATE_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
, WIP_LINES LI
, CST_COST_UPDATES CO
, ORG_ACCT_PERIODS AC
, WIP_ENTITIES EN
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 4
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 TR.COST_UPDATE_ID = CO.COST_UPDATE_ID
AND TR.LINE_ID = LI.LINE_ID (+)
AND TR.ORGANIZATION_ID = LI.ORGANIZATION_ID (+)
AND TR.REASON_ID = MTR.REASON_ID (+)
AND '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY