APPS.CSTFV_MFG_TXN_DISTRIBUTIONS
[Home] [Help]
| Product: | BOM - Bills of Material |
|---|---|
| Description: | - Retrofitted |
| Implementation/DBA Data: |
APPS.CSTFV_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 */ 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