DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1610: mtl_system_items_kfv mtl,

1606: mtl.concatenated_segments part_number,
1607: csi.serial_number serial_number,
1608: mr.title mr_title
1609: FROM ahl_mr_headers_vl mr,
1610: mtl_system_items_kfv mtl,
1611: csi_item_instances csi
1612: WHERE mr.mr_header_id = c_mr_header_id
1613: AND csi.instance_id = c_item_instance_id
1614: AND csi.inventory_item_id = mtl.inventory_item_id

Line 1625: mtl_system_items_kfv mtl,

1621: csi.serial_number serial_number,
1622: null mr_title
1623: FROM cs_incident_types_vl cit,
1624: cs_incidents_all_b cs,
1625: mtl_system_items_kfv mtl,
1626: csi_item_instances csi
1627: WHERE cs.incident_id = cs_incident_id
1628: AND cit.incident_type_id = cs.incident_type_id
1629: AND csi.instance_id = c_item_instance_id

Line 3463: mtl_system_items_kfv mtl,

3459: mtl.concatenated_segments part_number,
3460: csi.serial_number serial_number,
3461: mr.title mr_title
3462: FROM ahl_mr_headers_vl mr,
3463: mtl_system_items_kfv mtl,
3464: csi_item_instances csi
3465: WHERE mr.mr_header_id = c_mr_header_id
3466: AND csi.instance_id = c_item_instance_id
3467: AND csi.inventory_item_id = mtl.inventory_item_id

Line 3478: mtl_system_items_kfv mtl,

3474: csi.serial_number serial_number,
3475: null mr_title
3476: FROM cs_incident_types_vl cit,
3477: cs_incidents_all_b cs,
3478: mtl_system_items_kfv mtl,
3479: csi_item_instances csi
3480: WHERE cs.incident_id = cs_incident_id
3481: AND cit.incident_type_id = cs.incident_type_id
3482: AND csi.instance_id = c_item_instance_id