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 87: From ahl_unit_effectivities_app_v aueb,

83: aueb.latest_due_date,
84: amh.description,
85: hp.party_type,
86: okch.authoring_org_id
87: From ahl_unit_effectivities_app_v aueb,
88: csi_item_instances csi,
89: ahl_mr_headers_vl amh,
90: hz_parties hp ,
91: okc_k_lines_b okcl,

Line 1005: From ahl_unit_effectivities_app_v aueb,

1001: csi.customer_product_id,
1002: cccv.counter_id,
1003: cccv.counter_name,
1004: nvl(cccv.net_reading,0) net_reading
1005: From ahl_unit_effectivities_app_v aueb,
1006: cs_incident_links cil,
1007: cs_incidents_all_b csi,
1008: csi_cp_counters_v cccv
1009: Where (aueb.status_code is NULL

Line 1182: From ahl_unit_effectivities_app_v aueb,

1178: jtb.scheduled_end_date,
1179: jtb.actual_start_date,
1180: jtb.actual_end_date,
1181: jtb.object_version_number tasks_object_version
1182: From ahl_unit_effectivities_app_v aueb,
1183: cs_incident_links cil,
1184: cs_incidents_all_b csi,
1185: jtf_tasks_b jtb
1186: Where aueb.status_code in ('TERMINATED','EXCEPTION')