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.EAM_WORKORDER_UTIL_PKG dependencies on WIP_PERIOD_BALANCES

Line 1004: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

1000:
1001: -- bug fix 2675869: removed 'distinct' from following query and added additonal ROWNUM<=1
1002: SELECT '1'
1003: into charges_exist_1
1004: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
1005: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
1006: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
1007: AND DJ.WIP_ENTITY_ID = x_wip_id
1008: AND DJ.ORGANIZATION_ID = x_org_id

Line 1138: DELETE FROM wip_period_balances

1134: END IF;
1135:
1136: /* End of Check for Material and Resource Transactions */
1137:
1138: DELETE FROM wip_period_balances
1139: WHERE wip_entity_id = x_wip_id
1140: AND NVL(repetitive_schedule_id, -1) =
1141: NVL(x_rep_id, -1)
1142: AND organization_id = x_org_id;

Line 1298: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

1294: begin
1295: -- bug fix 2675869: removed 'distinct' from following query and added additonal ROWNUM<=1
1296: SELECT '1'
1297: into charges_exist_1
1298: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
1299: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
1300: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
1301: AND DJ.WIP_ENTITY_ID = x_wip_id
1302: AND DJ.ORGANIZATION_ID = x_org_id