eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AX_WIP_TRANSACTION_ACCOUNTS_V1

Product:	AX - Global Accounting Engine
Description:	Account code combinations of each WIP transaction source
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MTA.TRANSACTION_ID
, 'IV' ROW_TYPE
, MTA.REFERENCE_ACCOUNT
, MTA.INVENTORY_ITEM_ID
, MTA.TRANSACTION_DATE
, MTA.TRANSACTION_VALUE
, MTA.ACCOUNTING_LINE_TYPE
, MTA.BASE_TRANSACTION_VALUE
, MTA.COST_ELEMENT_ID
, MTA.TRANSACTION_SOURCE_ID
, MTA.REPETITIVE_SCHEDULE_ID
, MTA.ORGANIZATION_ID
, NULL CLASS_CODE
, NULL ATTRIBUTE1
FROM MTL_TRANSACTION_ACCOUNTS MTA
, AX_EVENTS AE
WHERE MTA.ACCOUNTING_LINE_TYPE NOT IN (7
, 8)
AND AE.EVENT_FIELD1 = MTA.TRANSACTION_ID
AND AE.TRANSLATION_STATUS <> 'T'
AND AE.EVENT_TYPE LIKE '%W' UNION SELECT MTA.TRANSACTION_ID
, 'DJ' ROW_TYPE
, MTA.REFERENCE_ACCOUNT
, MTA.INVENTORY_ITEM_ID
, MTA.TRANSACTION_DATE
, MTA.TRANSACTION_VALUE
, MTA.ACCOUNTING_LINE_TYPE
, MTA.BASE_TRANSACTION_VALUE
, MTA.COST_ELEMENT_ID
, MTA.TRANSACTION_SOURCE_ID
, MTA.REPETITIVE_SCHEDULE_ID
, WDJ.ORGANIZATION_ID
, WDJ.CLASS_CODE
, WAC.ATTRIBUTE1
FROM MTL_TRANSACTION_ACCOUNTS MTA
, AX_EVENTS AE
, WIP_DISCRETE_JOBS WDJ
, WIP_ACCOUNTING_CLASSES WAC
WHERE MTA.ACCOUNTING_LINE_TYPE IN (7
, 8)
AND NOT EXISTS ( SELECT 1
FROM WIP_REPETITIVE_SCHEDULES WRS
WHERE WRS.WIP_ENTITY_ID = MTA.TRANSACTION_SOURCE_ID )
AND AE.EVENT_FIELD1 = MTA.TRANSACTION_ID
AND AE.TRANSLATION_STATUS <> 'T'
AND AE.EVENT_TYPE LIKE '%W'
AND WDJ.WIP_ENTITY_ID = MTA.TRANSACTION_SOURCE_ID
AND WAC.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND WAC.CLASS_CODE = WDJ.CLASS_CODE UNION SELECT MTA.TRANSACTION_ID
, 'RS' ROW_TYPE
, MTA.REFERENCE_ACCOUNT
, MTA.INVENTORY_ITEM_ID
, MTA.TRANSACTION_DATE
, MTA.TRANSACTION_VALUE
, MTA.ACCOUNTING_LINE_TYPE
, MTA.BASE_TRANSACTION_VALUE
, MTA.COST_ELEMENT_ID
, MTA.TRANSACTION_SOURCE_ID
, MTA.REPETITIVE_SCHEDULE_ID
, WRI.ORGANIZATION_ID
, WRI.CLASS_CODE
, WAC.ATTRIBUTE1
FROM MTL_TRANSACTION_ACCOUNTS MTA
, AX_EVENTS AE
, WIP_REPETITIVE_SCHEDULES WRS
, WIP_REPETITIVE_ITEMS WRI
, WIP_ACCOUNTING_CLASSES WAC
WHERE MTA.ACCOUNTING_LINE_TYPE IN (7
, 8)
AND NOT EXISTS ( SELECT 1
FROM WIP_DISCRETE_JOBS WDJ
WHERE WDJ.WIP_ENTITY_ID = MTA.TRANSACTION_SOURCE_ID )
AND AE.EVENT_FIELD1 = MTA.TRANSACTION_ID
AND AE.TRANSLATION_STATUS <> 'T'
AND AE.EVENT_TYPE LIKE '%W'
AND WRS.WIP_ENTITY_ID = MTA.TRANSACTION_SOURCE_ID
AND WRI.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
AND WRI.LINE_ID = WRS.LINE_ID
AND WAC.ORGANIZATION_ID = WRI.ORGANIZATION_ID
AND WAC.CLASS_CODE = WRI.CLASS_CODE

Columns

Name
TRANSACTION_ID
ROW_TYPE
REFERENCE_ACCOUNT
INVENTORY_ITEM_ID
TRANSACTION_DATE
TRANSACTION_VALUE
ACCOUNTING_LINE_TYPE
BASE_TRANSACTION_VALUE
COST_ELEMENT_ID
TRANSACTION_SOURCE_ID
REPETITIVE_SCHEDULE_ID
ORGANIZATION_ID
CLASS_CODE
ATTRIBUTE1