VIEW: APPS.CSTFV_MFG_TXN_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ WTA.OVERHEAD_BASIS_FACTOR , WTA.TRANSACTION_DATE , WTA.TRANSACTION_VALUE , WTA.PRIMARY_QUANTITY , WTA.BASE_TRANSACTION_VALUE , WTA.RATE_OR_AMOUNT , '_LA:wta.accounting_line_type:MFG_LOOKUPS:CST_ACCOUNTING_LINE_TYPE:MEANING' , '_LA:wta.basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , WTA.CURRENCY_CODE , WTA.CURRENCY_CONVERSION_DATE , WTA.CURRENCY_CONVERSION_TYPE , WTA.CURRENCY_CONVERSION_RATE , /* RESOLVE FOREIGN KEY RESOLUTIONS */ BR.RESOURCE_CODE , BR1.RESOURCE_CODE , CA.ACTIVITY , '_KF:SQLGL:GL#:gcc' , MP.ORGANIZATION_CODE , HAOU.NAME , OGB.DESCRIPTION , WE.WIP_ENTITY_NAME , WRS.DESCRIPTION , '_LA:wt.transaction_type:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING' , /* ID */ WTA.RESOURCE_ID , WTA.ACTIVITY_ID , WTA.REFERENCE_ACCOUNT , WTA.ORGANIZATION_ID , WTA.GL_BATCH_ID , WTA.WIP_ENTITY_ID , WTA.REPETITIVE_SCHEDULE_ID , WTA.TRANSACTION_ID , WTA.CONTRA_SET_ID , WTA.BASIS_RESOURCE_ID , WTA.COST_ELEMENT_ID , /* WHO */ WTA.CREATION_DATE , WTA.CREATED_BY , WTA.LAST_UPDATE_DATE , WTA.LAST_UPDATED_BY FROM WIP_TRANSACTIONS WT, WIP_REPETITIVE_SCHEDULES WRS, WIP_ENTITIES WE, ORG_GL_BATCHES OGB, MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS HAOU, GL_CODE_COMBINATIONS GCC, CST_ACTIVITIES CA, BOM_RESOURCES BR, BOM_RESOURCES BR1, WIP_TRANSACTION_ACCOUNTS WTA WHERE WTA.TRANSACTION_ID = WT.TRANSACTION_ID AND WTA.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID(+) AND WTA.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND WTA.ORGANIZATION_ID = OGB.ORGANIZATION_ID(+) AND WTA.GL_BATCH_ID = OGB.GL_BATCH_ID(+) AND WTA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND WTA.ORGANIZATION_ID = HAOU.ORGANIZATION_ID AND WTA.REFERENCE_ACCOUNT = GCC.CODE_COMBINATION_ID AND WTA.ACTIVITY_ID = CA.ACTIVITY_ID(+) AND WTA.RESOURCE_ID = BR.RESOURCE_ID(+) AND WTA.BASIS_RESOURCE_ID = BR1.RESOURCE_ID(+) AND '_SEC:wta.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ WTA.OVERHEAD_BASIS_FACTOR
, WTA.TRANSACTION_DATE
, WTA.TRANSACTION_VALUE
, WTA.PRIMARY_QUANTITY
, WTA.BASE_TRANSACTION_VALUE
, WTA.RATE_OR_AMOUNT
, '_LA:WTA.ACCOUNTING_LINE_TYPE:MFG_LOOKUPS:CST_ACCOUNTING_LINE_TYPE:MEANING'
, '_LA:WTA.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, WTA.CURRENCY_CODE
, WTA.CURRENCY_CONVERSION_DATE
, WTA.CURRENCY_CONVERSION_TYPE
, WTA.CURRENCY_CONVERSION_RATE
, /* RESOLVE FOREIGN KEY RESOLUTIONS */ BR.RESOURCE_CODE
, BR1.RESOURCE_CODE
, CA.ACTIVITY
, '_KF:SQLGL:GL#:GCC'
, MP.ORGANIZATION_CODE
, HAOU.NAME
, OGB.DESCRIPTION
, WE.WIP_ENTITY_NAME
, WRS.DESCRIPTION
, '_LA:WT.TRANSACTION_TYPE:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING'
, /* ID */ WTA.RESOURCE_ID
, WTA.ACTIVITY_ID
, WTA.REFERENCE_ACCOUNT
, WTA.ORGANIZATION_ID
, WTA.GL_BATCH_ID
, WTA.WIP_ENTITY_ID
, WTA.REPETITIVE_SCHEDULE_ID
, WTA.TRANSACTION_ID
, WTA.CONTRA_SET_ID
, WTA.BASIS_RESOURCE_ID
, WTA.COST_ELEMENT_ID
, /* WHO */ WTA.CREATION_DATE
, WTA.CREATED_BY
, WTA.LAST_UPDATE_DATE
, WTA.LAST_UPDATED_BY
FROM WIP_TRANSACTIONS WT
, WIP_REPETITIVE_SCHEDULES WRS
, WIP_ENTITIES WE
, ORG_GL_BATCHES OGB
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HAOU
, GL_CODE_COMBINATIONS GCC
, CST_ACTIVITIES CA
, BOM_RESOURCES BR
, BOM_RESOURCES BR1
, WIP_TRANSACTION_ACCOUNTS WTA
WHERE WTA.TRANSACTION_ID = WT.TRANSACTION_ID
AND WTA.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID(+)
AND WTA.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WTA.ORGANIZATION_ID = OGB.ORGANIZATION_ID(+)
AND WTA.GL_BATCH_ID = OGB.GL_BATCH_ID(+)
AND WTA.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WTA.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND WTA.REFERENCE_ACCOUNT = GCC.CODE_COMBINATION_ID
AND WTA.ACTIVITY_ID = CA.ACTIVITY_ID(+)
AND WTA.RESOURCE_ID = BR.RESOURCE_ID(+)
AND WTA.BASIS_RESOURCE_ID = BR1.RESOURCE_ID(+)
AND '_SEC:WTA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY