Product: | AX - Global Accounting Engine |
---|---|
Description: | standard and repetitive jobs information |
Implementation/DBA Data: | Not implemented in this database |
SELECT WDJ.WIP_ENTITY_ID WIP_ENTITY_ID
, WDJ.ORGANIZATION_ID ORGANIZATION_ID
, WDJ.CLASS_CODE CLASS_CODE
, WDJ.MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, WDJ.MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, WDJ.RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, WDJ.OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, WDJ.OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, WDJ.MATERIAL_VARIANCE_ACCOUNT MATERIAL_VARIANCE_ACCOUNT
, WDJ.RESOURCE_VARIANCE_ACCOUNT RESOURCE_VARIANCE_ACCOUNT
, WDJ.OVERHEAD_VARIANCE_ACCOUNT OVERHEAD_VARIANCE_ACCOUNT
, WDJ.OUTSIDE_PROC_VARIANCE_ACCOUNT OUTSIDE_PROC_VARIANCE_ACCOUNT
, MMT.TRANSACTION_ID TRANSACTION_ID
FROM WIP_DISCRETE_JOBS WDJ
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.TRANSACTION_SOURCE_ID = WDJ.WIP_ENTITY_ID UNION SELECT WRS.WIP_ENTITY_ID WIP_ENTITY_ID
, WRS.ORGANIZATION_ID ORGANIZATION_ID
, WRI.CLASS_CODE CLASS_CODE
, WRS.MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, WRS.MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, WRS.RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, WRS.OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, WRS.OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, WRS.MATERIAL_VARIANCE_ACCOUNT MATERIAL_VARIANCE_ACCOUNT
, WRS.RESOURCE_VARIANCE_ACCOUNT RESOURCE_VARIANCE_ACCOUNT
, WRS.OVERHEAD_VARIANCE_ACCOUNT OVERHEAD_VARIANCE_ACCOUNT
, WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT OUTSIDE_PROC_VARIANCE_ACCOUNT
, MMT.TRANSACTION_ID TRANSACTION_ID
FROM WIP_REPETITIVE_SCHEDULES WRS
, WIP_REPETITIVE_ITEMS WRI
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE WRI.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID AND WRI.LINE_ID = WRS.LINE_ID AND MMT.TRANSACTION_SOURCE_ID = WRS.WIP_ENTITY_ID AND MMT.REPETITIVE_LINE_ID = WRS.LINE_ID