APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 7: -- : Replaced ahl_unit_effectivities_b with ahl_unit_effectivities_app_v

3: -- Start of Comments
4: -- Package name : CSF_Preventive_Maintenance_PVT
5: -- Purpose : Preventive Maintenace Concurrent Program API.
6: -- History : Initial version for release 11.5.9
7: -- : Replaced ahl_unit_effectivities_b with ahl_unit_effectivities_app_v
8: -- for 11.5.10.
9: -- NOTE :
10: -- End of Comments
11:

Line 84: From ahl_unit_effectivities_app_v aueb,

80: aueb.earliest_due_date,
81: aueb.latest_due_date,
82: amh.description,
83: hp.party_type
84: From ahl_unit_effectivities_app_v aueb,
85: csi_item_instances csi,
86: ahl_mr_headers_vl amh,
87: hz_parties hp
88: Where nvl(aueb.earliest_due_date,aueb.due_date) <= trunc(sysdate) + p_period_size

Line 965: From ahl_unit_effectivities_app_v aueb,

961: csi.customer_product_id,
962: cccv.counter_id,
963: cccv.counter_name,
964: nvl(cccv.net_reading,0) net_reading
965: From ahl_unit_effectivities_app_v aueb,
966: cs_incident_links cil,
967: cs_incidents_all_b csi,
968: csi_cp_counters_v cccv
969: Where (aueb.status_code is NULL

Line 1135: From ahl_unit_effectivities_app_v aueb,

1131: jtb.scheduled_end_date,
1132: jtb.actual_start_date,
1133: jtb.actual_end_date,
1134: jtb.object_version_number tasks_object_version
1135: From ahl_unit_effectivities_app_v aueb,
1136: cs_incident_links cil,
1137: cs_incidents_all_b csi,
1138: jtf_tasks_b jtb
1139: Where aueb.status_code in ('TERMINATED','EXCEPTION')