Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTBV_MATL_TXN_DISTRIBUTIONS |
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 */ /* 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
, '_LA:MTA.TRANSACTION_SOURCE_TYPE_ID:MFG_LOOKUPS:MTL_DISPOSITION:MEANING'
, 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 MTL_TRANSACTION_ACCOUNTS MTA
WHERE '_SEC:MTA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY