DBA Data[Home] [Help]

APPS.EAM_FAILURE_ANALYSIS_PVT dependencies on WIP_EAM_PERIOD_BALANCES

Line 1598: FROM WIP_EAM_PERIOD_BALANCES WEPB, EAM_FAILURE_HISTORY_TEMP EFHT

1594:
1595: CURSOR c_cost_calc is
1596: SELECT SUM(WEPB.ACTUAL_MAT_COST+WEPB.ACTUAL_LAB_COST+WEPB.ACTUAL_EQP_COST) COST,
1597: WEPB.WIP_ENTITY_ID
1598: FROM WIP_EAM_PERIOD_BALANCES WEPB, EAM_FAILURE_HISTORY_TEMP EFHT
1599: WHERE EFHT.GROUP_ID = p_group_id
1600: AND EFHT.MAINT_ORGANIZATION_ID = WEPB.ORGANIZATION_ID
1601: AND EFHT.WIP_ENTITY_ID = WEPB.WIP_ENTITY_ID
1602: AND EFHT.INCLUDE_FOR_COST_AGGR = 'Y'