Product: | BOM - Bills of Material |
---|---|
Description: | Repetitive schedule WIP reference object |
Implementation/DBA Data: | APPS.CST_XLA_REP_SCHED_REF_V |
SELECT X.TRANSACTION_ID TRANSACTION_ID
, WRS.REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, WRS.WIP_ENTITY_ID REP_SCHED_WIP_ENTITY_ID
, WRS.LINE_ID REP_SCHED_LINE_ID
, WRS.MATERIAL_ACCOUNT REP_SCHED_MATERIAL_ACCOUNT
, WRS.MATERIAL_OVERHEAD_ACCOUNT REP_SCHED_MATL_OVHD_ACCOUNT
, WRS.RESOURCE_ACCOUNT REP_SCHED_RESOURCE_ACCOUNT
, WRS.OVERHEAD_ACCOUNT REP_SCHED_OVERHEAD_ACCOUNT
, WRS.OUTSIDE_PROCESSING_ACCOUNT REP_SCHED_OUT_PROC_ACCOUNT
FROM WIP_REPETITIVE_SCHEDULES WRS
, ( SELECT TRANSACTION_ID
, MIN(REPETITIVE_SCHEDULE_ID) REPETITIVE_SCHEDULE_ID
FROM MTL_MATERIAL_TXN_ALLOCATIONS GROUP BY TRANSACTION_ID ) X
WHERE X.REPETITIVE_SCHEDULE_ID = WRS.REPETITIVE_SCHEDULE_ID