VIEW: APPS.CSTFV_MATL_TXN_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ MTA.TRANSACTION_DATE , MTA.TRANSACTION_VALUE , MTA.PRIMARY_QUANTITY , MTA.BASE_TRANSACTION_VALUE , MTA.RATE_OR_AMOUNT , '_LA:mta.accounting_line_type:MFG_LOOKUPS:CST_ACCOUNTING_LINE_TYPE:MEANING' , '_LA:mta.basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , MTA.CURRENCY_CODE , MTA.CURRENCY_CONVERSION_DATE , MTA.CURRENCY_CONVERSION_TYPE , MTA.CURRENCY_CONVERSION_RATE , /* RESOLVE FOREIGN KEY RESOLUTIONS */ BR.RESOURCE_CODE , CA.ACTIVITY , '_KF:SQLGL:GL#:gcc' , MP.ORGANIZATION_CODE , HAOU.NAME , OGB.DESCRIPTION , WRS.DESCRIPTION , MMT.TRANSACTION_TYPE_ID , CCE.COST_ELEMENT , '_KF:INV:MSTK:msi' , MTST.TRANSACTION_SOURCE_TYPE_NAME , GET.ENCUMBRANCE_TYPE , FC.NAME , '_LA:mta.transaction_source_type_id:MFG_LOOKUPS:MTL_DISPOSITION:MEANING' , /* ID */ MTA.RESOURCE_ID , MTA.ACTIVITY_ID , MTA.REFERENCE_ACCOUNT , MTA.ORGANIZATION_ID , MTA.GL_BATCH_ID , MTA.REPETITIVE_SCHEDULE_ID , MTA.TRANSACTION_ID , MTA.CONTRA_SET_ID , MTA.COST_ELEMENT_ID , MTA.INVENTORY_ITEM_ID ,MTA.TRANSACTION_SOURCE_ID , MTA.ENCUMBRANCE_TYPE_ID , /* WHO */ MTA.CREATION_DATE , MTA.CREATED_BY , MTA.LAST_UPDATE_DATE , MTA.LAST_UPDATED_BY ,MTA.TRANSACTION_SOURCE_TYPE_ID FROM CST_COST_ELEMENTS CCE, FND_CURRENCIES_VL FC, GL_ENCUMBRANCE_TYPES GET, MTL_TXN_SOURCE_TYPES MTST, MTL_SYSTEM_ITEMS MSI, MTL_MATERIAL_TRANSACTIONS MMT, WIP_REPETITIVE_SCHEDULES WRS, ORG_GL_BATCHES OGB, MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS HAOU, GL_CODE_COMBINATIONS GCC, CST_ACTIVITIES CA, BOM_RESOURCES BR, MTL_TRANSACTION_ACCOUNTS MTA WHERE MTA.CURRENCY_CODE = FC.CURRENCY_CODE(+) AND MTA.ENCUMBRANCE_TYPE_ID = GET.ENCUMBRANCE_TYPE_ID(+) AND MTA.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID(+) AND MTA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MTA.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MTA.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID(+) AND MTA.TRANSACTION_ID = MMT.TRANSACTION_ID(+) AND MTA.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID(+) /* EVEN THOUGH GL_BATCH_ID IS NOT NULL WE USE OUTER JOIN SINCE IT CAN TAKE A VALUE OF -1 (ALGORITHM LOGIC) THAT DOES NOT BELONG TO OGB */ AND MTA.GL_BATCH_ID = OGB.GL_BATCH_ID(+) AND MTA.ORGANIZATION_ID = OGB.ORGANIZATION_ID(+) AND MTA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MTA.ORGANIZATION_ID = HAOU.ORGANIZATION_ID AND MTA.REFERENCE_ACCOUNT = GCC.CODE_COMBINATION_ID(+) AND MTA.ACTIVITY_ID = CA.ACTIVITY_ID(+) AND MTA.RESOURCE_ID = BR.RESOURCE_ID(+) AND '_SEC:mta.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ MTA.TRANSACTION_DATE
, MTA.TRANSACTION_VALUE
, MTA.PRIMARY_QUANTITY
, MTA.BASE_TRANSACTION_VALUE
, MTA.RATE_OR_AMOUNT
, '_LA:MTA.ACCOUNTING_LINE_TYPE:MFG_LOOKUPS:CST_ACCOUNTING_LINE_TYPE:MEANING'
, '_LA:MTA.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, MTA.CURRENCY_CODE
, MTA.CURRENCY_CONVERSION_DATE
, MTA.CURRENCY_CONVERSION_TYPE
, MTA.CURRENCY_CONVERSION_RATE
, /* RESOLVE FOREIGN KEY RESOLUTIONS */ BR.RESOURCE_CODE
, CA.ACTIVITY
, '_KF:SQLGL:GL#:GCC'
, MP.ORGANIZATION_CODE
, HAOU.NAME
, OGB.DESCRIPTION
, WRS.DESCRIPTION
, MMT.TRANSACTION_TYPE_ID
, CCE.COST_ELEMENT
, '_KF:INV:MSTK:MSI'
, MTST.TRANSACTION_SOURCE_TYPE_NAME
, GET.ENCUMBRANCE_TYPE
, FC.NAME
, '_LA:MTA.TRANSACTION_SOURCE_TYPE_ID:MFG_LOOKUPS:MTL_DISPOSITION:MEANING'
, /* ID */ MTA.RESOURCE_ID
, MTA.ACTIVITY_ID
, MTA.REFERENCE_ACCOUNT
, MTA.ORGANIZATION_ID
, MTA.GL_BATCH_ID
, MTA.REPETITIVE_SCHEDULE_ID
, MTA.TRANSACTION_ID
, MTA.CONTRA_SET_ID
, MTA.COST_ELEMENT_ID
, MTA.INVENTORY_ITEM_ID
, MTA.TRANSACTION_SOURCE_ID
, MTA.ENCUMBRANCE_TYPE_ID
, /* WHO */ MTA.CREATION_DATE
, MTA.CREATED_BY
, MTA.LAST_UPDATE_DATE
, MTA.LAST_UPDATED_BY
, MTA.TRANSACTION_SOURCE_TYPE_ID
FROM CST_COST_ELEMENTS CCE
, FND_CURRENCIES_VL FC
, GL_ENCUMBRANCE_TYPES GET
, MTL_TXN_SOURCE_TYPES MTST
, MTL_SYSTEM_ITEMS MSI
, MTL_MATERIAL_TRANSACTIONS MMT
, WIP_REPETITIVE_SCHEDULES WRS
, ORG_GL_BATCHES OGB
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HAOU
, GL_CODE_COMBINATIONS GCC
, CST_ACTIVITIES CA
, BOM_RESOURCES BR
, MTL_TRANSACTION_ACCOUNTS MTA
WHERE MTA.CURRENCY_CODE = FC.CURRENCY_CODE(+)
AND MTA.ENCUMBRANCE_TYPE_ID = GET.ENCUMBRANCE_TYPE_ID(+)
AND MTA.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID(+)
AND MTA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MTA.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MTA.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID(+)
AND MTA.TRANSACTION_ID = MMT.TRANSACTION_ID(+)
AND MTA.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID(+) /* EVEN THOUGH GL_BATCH_ID IS NOT NULL WE USE OUTER JOIN SINCE IT CAN TAKE A VALUE OF -1 (ALGORITHM LOGIC) THAT DOES NOT BELONG TO OGB */
AND MTA.GL_BATCH_ID = OGB.GL_BATCH_ID(+)
AND MTA.ORGANIZATION_ID = OGB.ORGANIZATION_ID(+)
AND MTA.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MTA.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND MTA.REFERENCE_ACCOUNT = GCC.CODE_COMBINATION_ID(+)
AND MTA.ACTIVITY_ID = CA.ACTIVITY_ID(+)
AND MTA.RESOURCE_ID = BR.RESOURCE_ID(+)
AND '_SEC:MTA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY