Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTBV_MFG_TXN_DISTRIBUTIONS |
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 */ /* 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_TRANSACTION_ACCOUNTS WTA
WHERE '_SEC:WTA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY