DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_APPROVALS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 42: jtf_notes_vl note, mtl_system_items_kfv mtl

38: cs.summary,
39: udf.object_version_number
40: FROM ahl_unit_deferrals_b udf, ahl_unit_effectivities_b ue,
41: cs_incidents_all_vl cs, ahl_mel_cdl_ata_sequences mca, csi_item_instances csi,
42: jtf_notes_vl note, mtl_system_items_kfv mtl
43: WHERE udf.unit_effectivity_id = ue.unit_effectivity_id
44: AND ue.csi_item_instance_id = csi.instance_id
45: AND ue.cs_incident_id = cs.incident_id
46: AND udf.ata_sequence_id = mca.MEL_CDL_ATA_SEQUENCE_ID

Line 2163: csi_item_instances csi, mtl_system_items_kfv mtl,

2159: vst.visit_id = tsk.visit_id and tsk.unit_effectivity_id =
2160: ue.unit_effectivity_id and rownum < 2) visit_number
2161: from cs_incidents_all_vl cs, cs_incident_types_vl cit,
2162: ahl_unit_effectivities_b ue, ahl_unit_deferrals_b udf,
2163: csi_item_instances csi, mtl_system_items_kfv mtl,
2164: ahl_mel_cdl_ata_sequences seq, ahl_repair_categories arc,
2165: ahl_mel_cdl_headers mch, ahl_pc_headers_b aph, ahl_pc_nodes_b apn,
2166: cs_incident_urgencies_vl ciu
2167: where udf.unit_effectivity_id = ue.unit_effectivity_id