DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1626: mtl_system_items_kfv mtl,

1622: mtl.concatenated_segments part_number,
1623: csi.serial_number serial_number,
1624: mr.title mr_title
1625: FROM ahl_mr_headers_vl mr,
1626: mtl_system_items_kfv mtl,
1627: csi_item_instances csi
1628: WHERE mr.mr_header_id = c_mr_header_id
1629: AND csi.instance_id = c_item_instance_id
1630: AND csi.inventory_item_id = mtl.inventory_item_id

Line 1641: mtl_system_items_kfv mtl,

1637: csi.serial_number serial_number,
1638: null mr_title
1639: FROM cs_incident_types_vl cit,
1640: cs_incidents_all_b cs,
1641: mtl_system_items_kfv mtl,
1642: csi_item_instances csi
1643: WHERE cs.incident_id = cs_incident_id
1644: AND cit.incident_type_id = cs.incident_type_id
1645: AND csi.instance_id = c_item_instance_id

Line 3509: mtl_system_items_kfv mtl,

3505: mtl.concatenated_segments part_number,
3506: csi.serial_number serial_number,
3507: mr.title mr_title
3508: FROM ahl_mr_headers_vl mr,
3509: mtl_system_items_kfv mtl,
3510: csi_item_instances csi
3511: WHERE mr.mr_header_id = c_mr_header_id
3512: AND csi.instance_id = c_item_instance_id
3513: AND csi.inventory_item_id = mtl.inventory_item_id

Line 3524: mtl_system_items_kfv mtl,

3520: csi.serial_number serial_number,
3521: null mr_title
3522: FROM cs_incident_types_vl cit,
3523: cs_incidents_all_b cs,
3524: mtl_system_items_kfv mtl,
3525: csi_item_instances csi
3526: WHERE cs.incident_id = cs_incident_id
3527: AND cit.incident_type_id = cs.incident_type_id
3528: AND csi.instance_id = c_item_instance_id