View: CSTFV_MATL_TXN_DISTRIBUTIONS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTFV_MATL_TXN_DISTRIBUTIONS

View Text

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

Columns