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.

APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on WIP_PERIOD_BALANCES

Line 858: WIP_PERIOD_BALANCES wpb

854: g_program_application_id PROGRAM_APPLICATION_ID,
855: g_request_id REQUEST_ID
856: FROM
857: OPI_DBI_JOBS_F jobs,
858: WIP_PERIOD_BALANCES wpb
859: WHERE jobs.Status = 'Closed'
860: AND jobs.organization_id = wpb.organization_id
861: AND jobs.job_id = decode (wpb.class_type,
862: 1, wpb.wip_entity_id,

Line 1154: , WIP_PERIOD_BALANCES wpb

1150: , WPB.TL_RESOURCE_OUT
1151: , WPB.TL_SCRAP_IN
1152: , WPB.TL_SCRAP_OUT
1153: FROM OPI_DBI_JOBS_STG jobs
1154: , WIP_PERIOD_BALANCES wpb
1155: WHERE jobs.Status = 'Closed'
1156: AND jobs.ORGANIZATION_ID = wpb.ORGANIZATION_ID
1157: AND wpb.CLASS_TYPE IN (1, 5)
1158: AND jobs.job_id = wpb.wip_entity_id

Line 1191: , WIP_PERIOD_BALANCES wpb

1187: , WPB.TL_RESOURCE_OUT
1188: , WPB.TL_SCRAP_IN
1189: , WPB.TL_SCRAP_OUT
1190: FROM OPI_DBI_JOBS_STG jobs
1191: , WIP_PERIOD_BALANCES wpb
1192: WHERE jobs.Status = 'Closed'
1193: AND jobs.ORGANIZATION_ID = wpb.ORGANIZATION_ID
1194: AND wpb.CLASS_TYPE = 2
1195: AND jobs.Job_id = wpb.REPETITIVE_SCHEDULE_ID) jobs

Line 1711: wip_period_balances wpb

1707: tl_outside_processing_in + pl_material_in +
1708: pl_material_overhead_in + pl_resource_in +
1709: pl_overhead_in + pl_outside_processing_in) act_cost_b
1710: FROM
1711: wip_period_balances wpb
1712: GROUP BY
1713: wpb.organization_id,
1714: wpb.wip_entity_id,
1715: --decode(wpb.repetitive_schedule_id,null,1,2),