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.

VIEW: APPS.CST_XLA_REP_SCHED_REF_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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